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:
- Create a schema
- Create a table (in a schema)
- Create a view
- View (select) data
- Insert, update, or delete table data
- Drop tables or schemas
- Run procedures
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.