Category: ASE: Functions: User, Login and Role Functions

mut_excl_roles()

The role function mut_excl_roles() determines if two user defined roles or all roles, which are hierarchically contained in one of the roles declared in the parameters "role_1" or "role_2", are mutually exclusive. The function returns "1" if the roles mutually exclude each other . If not the return value is "0".

Syntax of the Role Function mut_excl_roles()

    mut_excl_roles("role_1", "role_2", ["membership" | "activation"])

The parameters of the Role Function mut_excl_roles()

role_1, role_2
The parameters "role_1" and "role_2" are placeholders for user defined roles.

membership, activation
The parameter "membership" and "activation" are optional parameters. They check on which level the roles override each other.

Example for the Role Function mut_excl_roles()

    alter role role_1 add exclusive membership role_2

    select mut_excl_roles("role_1", "role_2", "membership")

    go

    -----

    1

Shows that the roles "role_1" and "role_2" mutually exclude each other.

See also:
alter role,
create role,
drop role,
grant role,
revoke role,
set role,
has role(),
proc_role(),
role_contain(),
role_id(),
role_name(),
show_role(),
sp_activeroles,
sp_displayroles,
sp_role,
suser_id(),
suser_name(),
user,
user_id(),
user_name(),
valid_user() and
Functions.

ASE T-SQL - Aggregate Functions,
ASE T-SQL - User,
proc_role(),
role_contain(),
role_id(),
role_name(),
show_role(),
suser_id(),
suser_name(),
user,
user_id(),
user_name(),
valid_name(),
valid_user().