RDB$ROLES
stores the roles that have been defined in this database.
Column Name |
Data Type |
Description |
RDB$ROLE_NAME
|
CHAR(63)
|
Role name |
RDB$OWNER_NAME
|
CHAR(63)
|
The username of the role owner |
RDB$DESCRIPTION
|
BLOB TEXT
|
Could store comments related to the role |
RDB$SYSTEM_FLAG
|
SMALLINT
|
System flag |
RDB$SECURITY_CLASS
|
CHAR(63)
|
May reference a security class defined in the table RDB$SECURITY_CLASSES , to apply access control limits to all users of this role |
RDB$SYSTEM_PRIVILEGES
|
BINARY(8)
|
Bitset with the system privileges granted to a role, with the following bits
0 - unused 1 - USER_MANAGEMENT 2 - READ_RAW_PAGES 3 - CREATE_USER_TYPES 4 - USE_NBACKUP_UTILITY 5 - CHANGE_SHUTDOWN_MODE 6 - TRACE_ANY_ATTACHMENT 7 - MONITOR_ANY_ATTACHMENT 8 - ACCESS_SHUTDOWN_DATABASE 9 - CREATE_DATABASE 10 - DROP_DATABASE 11 - USE_GBAK_UTILITY 12 - USE_GSTAT_UTILITY 13 - USE_GFIX_UTILITY 14 - IGNORE_DB_TRIGGERS 15 - CHANGE_HEADER_SETTINGS 16 - SELECT_ANY_OBJECT_IN_DATABASE 17 - ACCESS_ANY_OBJECT_IN_DATABASE 18 - MODIFY_ANY_OBJECT_IN_DATABASE 19 - CHANGE_MAPPING_RULES 20 - USE_GRANTED_BY_CLAUSE 21 - GRANT_REVOKE_ON_ANY_OBJECT 22 - GRANT_REVOKE_ANY_DDL_RIGHT 23 - CREATE_PRIVILEGED_ROLES 24 - GET_DBCRYPT_INFO 25 - MODIFY_EXT_CONN_POOL 26 - REPLICATE_INTO_DATABASE 27 - PROFILE_ANY_ATTACHMENT |