Set 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 in the Ingres SQL Reference Guide.
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) Statement).