D.39 RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
stores the SQL access privileges for Firebird users and privileged objects.
Column Name | Data Type | Description |
---|
RDB$USER
| CHAR(63)
| The user or object that is granted this privilege |
RDB$GRANTOR
| CHAR(63)
| The user who grants the privilege |
RDB$PRIVILEGE
| CHAR(6)
| The privilege granted hereby: A - all (all privileges) S - select (selecting data) I - insert (inserting rows) D - delete (deleting rows) R - references (foreign key) U - update (updating data) X - executing (procedure) G - usage (of other object types) M - role membership C - DDL privilege create L - DDL privilege alter O - DDL privilege drop
|
RDB$GRANT_OPTION
| SMALLINT
| Whether the WITH GRANT OPTION authority is included with the privilege: 0 - not included 1 - included
|
RDB$RELATION_NAME
| CHAR(63)
| The name of the object (table, view, procedure or role) the privilege is granted ON |
RDB$FIELD_NAME
| CHAR(63)
| The name of the column the privilege is applicable to, for a column-level privilege (an UPDATE or REFERENCES privilege) |
RDB$USER_TYPE
| SMALLINT
| Identifies the type of user the privilege is granted TO (a user, a procedure, a view, etc.) |
RDB$OBJECT_TYPE
| SMALLINT
| Identifies the type of the object the privilege is granted ON 0 - table 1 - view 2 - trigger 5 - procedure 7 - exception 8 - user 9 - domain 11 - character set 13 - role 14 - generator (sequence) 15 - function 16 - BLOB filter 17 - collation 18 - package
|