role_name

Description

Returns the role name of the specified role ID.

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

Documentation Transact-SQL Users Guide

Functions mut_excl_roles, proc_role, role_contain, role_id