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