7.13 DBMS_SESSION

Table of Contents Previous Next


7 Built-In Packages : 7.13 DBMS_SESSION

Advanced Server provides support for the DBMS_SESSION.SET_ROLE procedure.
SET_ROLE(role_cmd)
Executes a SET ROLE statement followed by the string value specified in role_cmd.
Advanced Server's implementation of DBMS_SESSION is a partial implementation when compared to Oracle's version. Only DBMS_SESSION.SET_ROLE is supported.
7.13.1 SET_ROLE
The SET_ROLE procedure sets the current session user to the role specified in role_cmd. After invoking the SET_ROLE procedure, the current session will use the permissions assigned to the specified role. The signature of the procedure is:
SET_ROLE(role_cmd)
The SET_ROLE procedure appends the value specified for role_cmd to the SET ROLE statement, and then invokes the statement.
role_cmd specifies a role name in the form of a string value.
The following call to the SET_ROLE procedure invokes the SET ROLE command to set the identity of the current session user to manager:

7 Built-In Packages : 7.13 DBMS_SESSION

Table of Contents Previous Next