Name
USER_GRANT_ROLE — Assign an existing role to an existing security object.
Synopsis
USER_GRANT_ROLE
(
|
in name varchar , |
| in role varchar , | |
in
grant_opt
int
); |
Description
This function is used to assign an existing role to an existing
security object. This is the same as the
GRANT <role>
statement.
All roles assigned to the role object will be inherited.
Parameters
name
The name of the security object to affect.
role
The name of the role (group) to be assigned to the security object.
grant_option
A flag (0 or 1) indicating whether this object can grant this role to other security objects.
Return Types
None