To grant audit-related privileges in SQL, you use the SQL GRANT statement.

Once a SQL DBA grants the audit administrator privilege to a user:

  • The SQL products DBA will retain the ability to SELECT (read) on all audit policy and databases.
  • The SQL DBA will retain the ability to revoke an audit privilege for a user account that was granted by an audit administrator.
  • SQL users will retain the ability to SELECT on the audit tables, if they have audit read privileges.

For details about the SQL GRANT statement, see Develop SQL for OpenEdge and OpenEdge SQL Reference.