Each row in the SYSDBSPACEPERM system view describes a privilege 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 privilege. |
privilege_type | SMALLINT |
The privilege that is granted to the grantee. For example, CREATE gives the grantee privilege to create objects on the dbspace. |
FOREIGN KEY (dbspace_id) REFERENCES SYS.ISYSDBSPACE (dbspace_id)
FOREIGN KEY (grantee) REFERENCES SYS.ISYSUSER (user_id)