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. |
FOREIGN KEY (dbspace_ID) references SYS.ISYSDBSPACE
FOREIGN KEY (grantee) references SYS.ISYSUSER (user_id)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |