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-33 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
|
