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	Datatype	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)
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