SYSSEQUENCEPERM system view

The SYSSEQUENCEPERM system view records the privileges that users or groups hold on sequences. The underlying system table for this view is ISYSSEQUENCEPERM.

Column name	Data type	Description
sequence_id	UNSIGNED BIGINT	The unique number assigned to each sequence.
grantee	UNSIGNED INT	The ID of the user or group with permissions to alter or drop the sequence.
grantor	UNSIGNED INT	The ID of the user who granted the permissions for the sequence.
privilege_type	SMALLINT	The type of privileges granted to the user or group on the sequence.

Constraints on underlying system table

PRIMARY KEY (sequence_id, grantee, privilege_type)

FOREIGN KEY (sequence_id) references SYS.ISYSSEQUENCE (object_id)

FOREIGN KEY (grantee) references SYS.ISYSUSER (user_id)

FOREIGN KEY (grantor) references SYS.ISYSUSER (user_id)

Discuss this page in DocCommentXchange.