mut_excl_roles

Syntax

mut_excl_roles (role1, role2 [membership | activation])

Parameters

• role1 – is one user-defined role in a mutually exclusive relationship.
• role2 – is the other user-defined role in a mutually exclusive relationship.
• level – is the level (membership or activation) at which the specified roles are exclusive.

Examples

• Example 1 – Shows that the admin and supervisor roles are mutually exclusive:

  alter role admin add exclusive membership supervisor
  select 
  mut_excl_roles("admin", "supervisor", "membership")

  -----------
            1

Usage

mut_excl_roles, a system function, returns information about the mutual exclusivity between two roles. If the System Security Officer defines role1 as mutually exclusive with role2 or a role directly contained by role2, mut_excl_roles returns 1. If the roles are not mutually exclusive, mut_excl_roles returns 0.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute mut_excl_roles.