Returns 1 if role2 contains role1.
role_contain("role1", "role2")
is the name of a system or user-defined role.
is the name of another system or user-defined role.
select role_contain("intern_role", "doctor_role")
----------- 1
select role_contain("specialist_role", "intern_role")
----------- 0
role_contain, a system function, returns 1 if role1 is contained by role2.
For more information about system functions, see “System functions”.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute role_contain.
Documents For more information about contained roles and role hierarchies, see the System Administration Guide.
Functions mut_excl_roles,proc_role,role_id, role_name
Commands alter role
System procedures sp_activeroles, sp_displayroles, sp_role
