role_name

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 – Returns the role name of ID 01:

  select role_name(01)

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

Usage

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute role_name.