8. SQL Statements : SET : Session With [No]Privileges
 
Share this page                  
Session With [No]Privileges
When an Ingres session starts, it receives a default set of privileges. The SET SESSION WITH [NO]PRIVILEGES statement can be used to add, drop, or set the session effective privileges.
The following options are available:
ADD PRIVILEGE
Adds the listed privileges to the pre-existing effective privileges for that session, provided the user has permission to use them.
DROP PRIVILEGE
Removes the listed privileges from the effective privileges for that session.
WITH NOPRIVILEGES
Sets no effective privileges for the session.
WITH PRIVILEGES=(priv {,priv})
Replaces the session privileges by the listed privileges, the user must have permission to use them.
WITH PRIVILEGES=ALL
Adds all granted privileges to the effective privileges for that session.
WITH PRIVILEGES=DEFAULT
Resets the session privileges to the default privileges as at session startup.
Note:  Only one of these options can be specified. Ingres applications that require specific privileges must use this command to ensure the session has the required privileges.