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)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |