mut_excl_roles

Returns information about the mutual exclusivity between two roles.

Syntax

mut_excl_roles (role1, role2 [membership | activation])

Parameters

Examples

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.

See also:
  • alter role, create role, drop role, grant, set, revoke in Reference Manual: Commands

  • Transact-SQL Users Guide

  • sp_activeroles, sp_displayroles in Reference Manual: Procedures

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute mut_excl_roles.

Related reference
proc_role
role_contain
role_id
role_name