PolarDB for PostgreSQL(Compatible with Oracle) provides the DBMS_SESSION.SET_ROLE stored procedure.
Functions and stored procedures
| Function or stored procedure | Return value type | Description |
|---|---|---|
| SET_ROLE(role_cmd) | N/A | Executes the SET_ROLE statement followed by the string value specified in role_cmd. |
The DBMS_SESSION stored procedure in PolarDB for PostgreSQL(Compatible with Oracle) is partially implemented when compared with Oracle's version. Only DBMS_SESSION.SET_ROLE is supported.
SET_ROLE
The SET_ROLE stored procedure sets the current session user to the role specified in role_cmd. After the current session invokes the SET_ROLE stored procedure, the session uses the permissions assigned to the specified role. The syntax for this stored procedure:
SET_ROLE(role_cmd)The SET_ROLE stored 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
The following example demonstrates a call to the SET_ROLE stored procedure which uses the SET_ROLE statement to set the identity of the current session user to manager.
exec DBMS_SESSION.SET_ROLE('manager');