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
GRANT (privilege)).