sysroles

All databases

Description

sysroles maps server role IDs to local role IDs.

Columns

The columns for sysroles are:

Name

Datatype

Description

id

int

Server role ID (srid)

lrid

int

Local role ID

type

smallint

Unused

status

int

Unused

When a database permission is granted to a role, if an entry for the role does not exist in sysroles, Adaptive Server adds an entry to sysroles to map the local role ID (lrid) to the server-wide role ID (srid) in syssrvroles.

Indexes