D.32 RDB$ROLES
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 user name 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 , in order 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 |