Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » Views » System views



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.

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