SYSDBSPACEPERM system view

Each row in the SYSDBSPACEPERM system view describes a permission on a dbspace file. The underlying system table for this view is ISYSDBSPACEPERM.

Column name Column type Description
dbspace_id SMALLINT Unique number identifying the dbspace. The system dbspace contains all system objects and has a dbspace_id of 0.
grantee UNSIGNED INT

The user ID of the user getting the permission.

privilege_type SMALLINT

The permission that is granted to the grantee. For example, CREATE gives the grantee permission to create objects on the dbspace.

Constraints on underlying system table

FOREIGN KEY (dbspace_ID) references SYS.ISYSDBSPACE

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

See also