myVertica  

Understanding Users and Roles



Every Vertica database has one or more users. When users connect to a database, they log on with credentials (username and password) that a superuser defines in the database.

Users, Privileges, and Roles in Vertica

Database users should have access to only the database resources they need to perform their tasks. To navigate these necessities, Vertica has users, privileges, and roles. For an overview, see Managing Users and Privileges.

About Users

In a Vertica database, you can have multiple users. To learn more about creating users and the different types of users, see About Database Users in the Vertica documentation.

About Privileges

Before Vertica executes a statement, it checks to see if the requesting user has the necessary privileges to perform the operation. To allow users, other than the superuser or object owner, to use an object, an authorized user must grant the other user privileges on the object. For example, to let a user create a table, the owner or superuser needs to grant the user “create” privileges on the schema where they want to create the table. For a list of privileges, see Privileges Required for Common Database Operations in the Vertica documentation.

About Roles

To make managing permissions easier, use roles. Using roles avoids having to manually grant sets of privileges user by user. For more information, see About Database Roles in the Vertica documentation.

Creating Users and Roles

As a superuser, you can create various database users. You can also create roles, which will eventually have certain privileges and users associated with them. For more information, see the following topics in the Vertica documentation:

Granting and Revoking Privileges

Privileges are granted to (or revoked from) users or roles through a collection of GRANT/REVOKE statements. For more information, see the following topics in the Vertica documentation:

Granting and Revoking Access to Roles

As a database administrator, you can grant users access to certain roles. This is beneficial because roles have certain privileges associated with them. By granting a user access to a role, you don’t need to manually assign the user specific privileges. For more information, see the following topics in the Vertica documentation:

Learn More

For more information about Vertica users, privileges, and roles, see our full documentation and browse our blogs: