Inform Vertica About the Kerberos Principal

Follow these steps to inform Vertica about the principal name and keytab location.

For information about the parameters that you are setting in this procedure, see Kerberos Configuration Parameters.

  1. Log in to the database as an administrator (typically ).

  2. Set the KerberosKeyTabFile configuration parameter to point to the location of the keytab file:

    => ALTER DATABASE mydb SET KerberosKeytabFile = '/etc/krb5.keytab';

    The keytab file must be in the same location (/etc/krb5.keytab in this example) on all nodes.

  3. Set the service name for the Vertica principal; for example, vertica:

    => ALTER DATABASE mydb SET KerberosServiceName = 'vertica';

  4. Provide the realm portion of the principal, for example, EXAMPLE.COM:

    => ALTER DATABASE mydb SET KerberosRealm = 'EXAMPLE.COM'