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.

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

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute role_name.

See also

Functions mut_excl_roles, proc_role, role_contain, role_id

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF