Mut_excl_roles

mut_excl_roles( ‘role_1’, ‘role_2’, [‘membership’ | ‘activation’] )

Returns 1 if the two user-defined roles (or roles contained in these roles) are defined as mutually exclusive, either on ‘membership’ or ‘activation’ level; otherwise returns 0.

Example

create role Test1

create role Test2

alter role Test1 add exclusive membership Test2

select mut_excl_roles( 'Test1', 'Test2', 'membership' )