role_contain

Determines whether a specified role is contained within another specified role.

Syntax

role_contain("role1", "role2")

Parameters

role1 – is the name of a system or user-defined role.
role2 – is the name of another system or user-defined role.

Examples

Example 1 – Determines whether intern_role is contained within doctor_role:
```
select role_contain("intern_role", "doctor_role")
```
```
-----------
1
```
Example 2 – Determines whether specialist_role is contained within intern_role:
```
select role_contain("specialist_role", "intern_role")
```
```
-----------
0
```

Usage

role_contain, a system function, returns 1 if role1 is contained by role2. Otherwise, role_contain returns 0.

See also:

alter role in Reference Manual: Commands
For more information about contained roles and role hierarchies, see the System Administration Guide. For system functions, see 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 role_contain.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com