8. SQL Statements : SET : Permissions
 
Share this page                  
Permissions
To issue the following statements, a user must have TRACE privilege:
SET [NO]LOCK_TRACE
SET [NO]PRINTQRY
SET [NO]RULES
SET [NO]PRINTRULES
SET [NO]PRINTDBEVENTS
SET [NO]LOGDBEVENTS
SET [NO]IO_TRACE
SET [NO]LOG_TRACE
SET [NO]TRACE POINT value
To issue the SET WORK LOCATIONS statement, the effective user of the session must have MAINTAIN_LOCATIONS privilege. For more information see CREATE USER and ALTER USER.
To issue the following statements, you must be the DBA of the database to which the session is attached:
SET [NO]RULES
SET [NO]LOGGING
To issue the SET LOCKMODE statement, the effective user of the session must have LOCKMODE privilege. LOCKMODE privilege is assigned using the GRANT statement (see page GRANT (privilege)).