SYSTEM.SPACEAUTH lists all users and authorization
groups for which TABLESPACE or SECTIONSPACE authority has been
granted.
Initially SYSTEM.SPACEAUTH contains a row having the column values
PUBLIC, SYSTEM, Y, Y. That is, all users have TABLESPACE and SECTIONSPACE
authority in the SYSTEM DBEFileSet.
A DBA can modify these authorities with further revokes and grants as
desired.
ALLBASE/SQL accesses
SYSTEM.SPACEAUTH whenever a user attempts to put a table or long column
or a section (generated by a PREPARE or DECLARE CURSOR statement)
into an explicit DBEFileSet. The owner of the table or section must have
TABLESPACE or SECTIONSPACE authority, respectively, on the DBEFileSet.
Table 8-32 System.Spaceauth
| Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | Authorized DBEUserID or authorization group |
| DBEFILESET | CHAR | 20 | DBEFileSet name for SECTIONSPACE or TABLESPACE authority |
| TABLESPACE | CHAR | 2 | Resource authority:
Y (The user has authority to store table and long
column data in this DBEFileSet.)
N (The user cannot store table and long column
data in this DBEFileSet.)
|
| SECTIONSPACE | CHAR | 2 | Resource authority:
Y (The user has authority to store sections
in this DBEFileSet.)
N (The user cannot store sections in this
DBEFileSet.)
|
EXAMPLE |
 |
SELECT * FROM System.Spaceauth;
--------------------+----------+----------+------------
USERID |DBEFILESET|TABLESPACE|SECTIONSPACE
--------------------+----------+----------+------------
PUBLIC |SYSTEM |Y |Y
PUBLIC |PURCHFS |Y |Y
PUBLIC |WAREHFS |Y |Y
PUBLIC |ORDERSFS |Y |Y
PUBLIC |FILESFS |Y |Y
PUBLIC |RECFS |Y |Y
--------------------------------------------------------------------------
Number of rows selected is 6
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
