SET Statement (set_statement) (SAP Library - Reference Manual: SAP DB 7.4)

SET Statement (set_statement)

The SET statement alters the properties of a database session.

Syntax

<set_statement> ::= SET ROLE ALL [EXCEPT <role_name>] | SET ROLE NONE
| SET ROLE <role_name> [IDENTIFIED BY <password>]
| SET ISOLATION LEVEL <unsigned_integer>

role_name, password, unsigned_integer

Explanation

SET ROLE

DEFAULT ROLE in the ALTER USER statement or ALTER USERGROUP statement specifies which of the roles assigned to the current user or user group is active in the user session or group member session. If a role is active, the current user has all the privileges that are included in the role.

If a role that is activated automatically when a session is opened is assigned to the current user with the alter user statement or ALTER USERGROUP statement, it is deactivated when the set statement is executed if it is not identified by the SET ROLE specification in the set statement.

ALL: all roles assigned to the current user are active. EXCEPT can be used to exclude specified roles from activation.

NONE: none of the roles is active.

Role name specified: the roles specified here must exist and be assigned to the current user. If a password exists for the role, it must be defined in the set statement in addition to the owner of the role.
The role identified with role name is activated.

ISOLATION LEVEL

Specifying an isolation level changes the lock behavior for all subsequent SQL statements of the current database session.

The isolation level is set using an integer without a plus/minus sign after the keywords ISOLATION LEVEL. The following values are permissible: 0, 1, 2, 3, 10, 15, 20, and 30.

Isolation Level 0

Isolation Level 1 or 10

Isolation Level 15

Isolation Level 2 or 20

Isolation Level 3 or 30