Proc_role

proc_role( ‘role_name’ )

Returns 1 if the current session has enabled the specified role directly, returns 2 if the role is contained in an enabled role; otherwise returns 0.

Examples

select proc_role( 'isah_replication_role' )

select proc_role( 'sa_role' )