PolarDB for Oracle support the following DBMS_SESSION.SET_ROLE procedure:
| Function/Procedure | Return type | Description |
|---|---|---|
| SET_ROLE(role_cmd) | N/A | Executes the SET ROLE statement followed by the string value specified in role_cmd.
|
The implementation of DBMS_AQ in PolarDB databases compatible with Oracle is a partial implementation when compared with native Oracle. Only DBMS_SESSION.SET_ROLE is supported.
SET_ROLE
The SET_ROLE procedure sets the current session user to the role specified in role_cmd. After the current session invokes the SET_ROLE procedure, the session uses the permissions assigned to the specified role. The procedure has the following signature:
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.
Parameters
| Parameter | Description |
|---|---|
| role_cmd | Specifies a role name in the form of a string value. |
Examples
You can run the SET ROLE command to call the SET_ROLE procedure and set the identity of the current session user to manager. The following example shows this call:
exec DBMS_SESSION.SET_ROLE('manager');