role_name

Description

Returns the name of a 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

role_name, a system function, returns the role name.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute role_name.

See also

For more information about system functions, see “System functions”.

Functions mut_excl_roles, proc_role, role_contain, role_id