ASSOCIATE_USER_CUSTOM_ROLE

Makes an existing database role available for granting to SCURTY users. This procedure may also be used to add or change a comment from the DBA for an already associated role.

This procedure does not grant the role but adds the role to the ADM_ALL_ROLES view and thus makes it available for granting (e.g. via p_rep_oper.grant_custom_role).

The database role must already exist and it must not be an Oracle internal role or contain an Oracle internal role.

This procedure can only be executed by a user who has been granted the ‘associate_custom_roles’ privilege, as stored in table ADM_ADMIN_PRIVS. By default, this is granted to the DBA role.

Inserts or updates a row in table ADM_USER_CUSTOM_ROLES.

Parameter Name	Required	DefaultValue	Values	Description
p_role	yes			The name of the role. The name is case sensitive.
p_dba_comment	no			A comment of the DBA regarding the role.

Example

Make role ‘R_GU_TABLES’ available for granting and add comment ‘Standard role for generic users’:

EXEC p_rep_admin.associate_user_custom_role
    ( 'R_GU_TABLES'
    , 'Standard role for generic users' );