About Database Privileges

When a database object is created, such as a schema, table, or view, that object is assigned an owner—the person who executed the CREATE statement. By default, database administrators (superusers) or object owners are the only users who can do anything with the object.

In order to allow other users to use an object, or remove a user's right to use an object, the authorized user must grant another user privileges on the object.

Privileges are granted (or revoked) through a collection of GRANT/REVOKE statements that assign the privilege—a type of permission that lets users perform an action on a database object, such as:

Before Vertica executes a statement, it determines if the requesting user has the necessary privileges to perform the operation.

For more information about the privileges associated with these resources, see Privileges That Can Be Granted on Objects.

Note: Vertica logs information about each grant (grantor, grantee, privilege, and so on) in the V_CATALOG.GRANTS system table.