Vertica Blog

Vertica Blog

Security

What’s New in Vertica 9.0.1: Security and Authentication

Soniya Shah, Information Developer
February 6, 2018

This blog post was authored by Soniya Shah. In this release, we introduce some security enhancements. We've added the ability to grant and revoke privileges on system tables, using the same syntax as you would for granting and revoking on tables. However, there are some limitations about the types of privileges you can use with...

Building a Secure Vertica Environment

Soniya Shah, Information Developer
September 14, 2017

This blog post was authored by Soniya Shah. Vertica has a client-server architecture system, where applications that reside on the client access the Vertica cluster through drivers including ODBC, JDBC, OLEDB and ADO.NET. This post discusses secure client to server communications, authenticating access to Vertica, and administrator access. Method Vertica Options Authentication: Validate user credentials...
Modern Database Analytics

LDAP and User Accounts

Soniya Shah, Information Developer
January 30, 2017

This blog post was authored by Soniya Shah. If you are a database administrator, you probably need to authenticate users in Vertica. There are many methods users can use to authenticate, including Ident, Kerberos, LDAP, and hash. This blog walks you through the steps to take if you want to authenticate some users using LDAP...
Programmer

Customize Your Security Authentication in Vertica

Soniya Shah, Information Developer
November 7, 2016

Learn more about authentication methods in Vertica.

Best Practices for Using LDAP Link with Vertica

Sarah Lemaire, Manager, Vertica Documentation
November 1, 2016

There are a few best practices that you should follow to make sure that you don't accidentally lose any users or data. This blog explains how to keep your LDAP Link service working smoothly.

Classified: FAQs on Access Policies

Sarah Lemaire, Manager, Vertica Documentation
May 2, 2016

In Vertica 7.2.2 we?ve added more security features, including a row-level access policy option. Combined with our previously existing column access policy, Vertica verifies that your data is more secure than ever.

User Security Auditing in Vertica

HPBigData_BP
March 9, 2016

Are you a database administer who manages users and roles in your Vertica database? Do you need to keep track of who has permission to access certain database objects? If so, here's a quick guide to queries that help you review the users, roles, privileges, and permissions that you have configured in your database. These...

Data-Centric Security: Vertica and SecureData

BD_Partner_Eng
December 3, 2015

Take advantage of the recent integration of Vertica and SecureData. This integration allows you to keep your data protected when it flows across multiple systems spread across multiple data centers on premise or in the cloud.

Using Inherited Privileges

Phil Molea, Sr. Information Developer, Vertica
November 16, 2015

New to Vertica 7.2.0, the inherited privileges feature provides a one-step method for enabling privileges at the schema level.

Kerberos Authentication for Hadoop Integration: Keeping your data safe

Sarah Lemaire, Manager, Vertica Documentation
August 27, 2015

Like all Vertica releases, 7.1.2 includes a bunch of new features. One specific feature can help make your HDFS data safer: Kerberos integration for Hadoop. This blog will give you an overview of using Kerberos authentication with Vertica for SQL on Hadoop.

What is a Lock Anyway?

Sarah Lemaire, Manager, Vertica Documentation
May 19, 2015

We talk a lot about database security and how you can protect your sensitive data from outside threats. But what about internal, unintentional data corruption? What if the data you are trying to analyze or manipulate is simultaneously being manipulated by another transaction? A scenario such as this could lead to data loss and inconsistency....
Modern Database Analytics

Configuring Vertica for a Multi-Tenant Solution

Curtis_1
April 27, 2015

One of the more interesting and popular Vertica solutions that I've come across is the so-called multi-tenant implementation. A multi-tenant database is simply a database designed to support multiple unique customers. Often, these customers interact with the database through some sort of web interface which uses an Vertica database in the backend.