role_id

Description

Returns the system role ID of the name you specify.

Syntax

role_id("role_name")

Parameters

role_name: is the name of a system or user-defined role. Role names and role IDs are stored in the syssrvroles system table.

Examples

Example 1

Returns the system role ID of sa_role:

select role_id("sa_role")

------
0

Example 2

Returns the system role ID of the “intern_role”:

select role_id("intern_role")

------
6

Usage

role_id, a system function, returns the system role ID (srid). System role IDs are stored in the srid column of the syssrvroles system table.

If the role_name is not a valid role in the system, Adaptive Server returns NULL.

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

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute role_id.