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 Data 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
 See also