Returns the role ID of the specified role name.
role_id("role_name")
select role_id("sa_role")
------ 0
select role_id("intern_role")
------ 6
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, the SAP ASE server returns NULL.
Roles – see the System Administration Guide
System functions – see Transact-SQL Users Guide.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute role_id.