RDB$USER PRIVILEGES

Go Up to System Tables

RDB$USER_PRIVILEGES keeps track of the privileges assigned to a user through a SQL GRANT statement. There is one occurrence of this table for each user/privilege intersection.

Column name	Data type	Length	Description
`RDB$USER`	`CHAR`	67	Names the user who was granted the privilege listed in the `RDB$PRIVILEGE` column.
`RDB$GRANTOR`	`CHAR`	67	Names the user who granted the privilege.
`RDB$PRIVILEGE`	`CHAR`	6	Identifies the privilege granted to the user listed in the `RDB$USER` column, above. The character stored in the field corresponds to the valid values listed below. Valid values are: `SELECT (S)` `DELETE (D)` `INSERT (I)` `UPDATE (U)` `REFERENCE (R)` `MEMBER OF (M)` (for roles) `DECRYPT (T)` `ENCRYPT (E)` `SUBSCRIBE (B)` `EXECUTE (X)` `TRUNCATE (Z)`
`RDB$GRANT_OPTION`	`SMALLINT`		Indicates whether the privilege was granted with the `WITH GRANT OPTION` (value of 1) or not (value of 0).
`RDB$RELATION_NAME`	`CHAR`	67	Identifies the table or role to which the privilege applies.
`RDB$FIELD_NAME`	`CHAR`	67	For update privileges, identifies the column to which the privilege applies.
`RDB$USER_TYPE`	`SMALLINT`
`RDB$OBJECT_TYPE`	`SMALLINT`