USER_GRANT_ROLE
Assign an existing role to an existing security object.
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.