Grant

Vertica defines GRANT in two ways:.

Vertica defines GRANT in two ways:

  1. Grant a user privileges to access database objects using any GRANT statement, except GRANT (Authentication).

  2. Associate a user-defined authentication method with a user through GRANT (Authentication). This operation differs from GRANT <privileges> as authentication methods are “associated” with a user or role and privileges are “granted” to a user or role.

Examples

Grant Access Privileges to a User

This example shows how to grant a user, Joe, privileges to access the online_sales schema:

=> GRANT USAGE ON SCHEMA online_sales TO Joe;

Associate an Authentication Method with a User

This example shows how to associate the v_ldap authentication method to user jsmith:

=> GRANT AUTHENTICATION v_ldap TO jsmith;