role_name

Description

Returns the name of a role whose system role ID you specify.

Syntax

role_name(role_id)

Parameters

role_id

is the system role ID (srid) of the role. Role names are stored in syssrvroles.

Examples

Example 1

select role_name(01)

------------------------------
sso_role                      

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension

Permissions

Any user can execute role_name.

See also

Functions mut_excl_roles,proc_role,role_contain, role_id