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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |