DISASSOCIATE_USER_CUSTOM_ROLE

Removes a database role from the available roles which can be granted to SCURTY users.

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.

It removes the role from ADM_USER_CUSTOM_ROLES table and ADM_ALL_ROLES view.

Parameter Name	Required	DefaultValue	Values	Description
p_role	yes			The name of the role. The name is case senstive.

Example

Remove role ‘R_GU_TABLES’ from those available for granting to SCURTY users:

EXEC p_rep_admin.disassociate_user_custom_role
    ( 'R_GU_TABLES' );