Appendix D. System Tables - D.39 RDB$USER_PRIVILEGES - 《Firebird 4.0 Language Reference》

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