Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Auditing : Audit Security : Managing audit privileges : Granting audit privileges : Granting audit privileges in SQL
 
Granting audit privileges in SQL
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 OpenEdge Data Management: SQL Development and OpenEdge Data Management: SQL Reference.