 |
» |
|
|
|
SYSTEM.TABAUTH contains the authorities for operations
on tables and views. If a user has been granted
authority to operate on only specific columns instead of
the entire table or view, you must also use SYSTEM.COLAUTH
to determine the actual columns. This view initially contains entries for the CATALOG views. The view
is updated whenever
ALLBASE/SQL processes a GRANT or REVOKE statement containing a
table or view related authority, and when PUBLIC or PUBLICREAD
tables are created.
It is also updated when a DROP TABLE, DROP VIEW, or table-related
TRANSFER OWNERSHIP statement is processed. SYSTEM.TABAUTH, along with SYSTEM.COLAUTH, SYSTEM.MODAUTH, SYSTEM.PROCAUTH,
and SYSTEM.SPECAUTH, contains the security scheme
for the DBEnvironment. ALLBASE/SQL verifies a user's authority
in SYSTEM.TABAUTH if the appropriate authority was not contained
in SYSTEM.SPECAUTH. If the UPDATE or REFERENCES column contains a C,
ALLBASE/SQL verifies the user's UPDATE authority in SYSTEM.COLAUTH. When you create a PUBLIC or PUBLICREAD table, ALLBASE/SQL implicitly
grants table authorities to the special user PUBLIC. In this case,
the GRANTOR column contains the table owner NAME and the
GRANTABLE column contains an N to indicate that privileges cannot be granted.
Table 8-36 System.Tabauth |
Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | Authorized DBEUserID or
authorization group
| | NAME | CHAR | 20 | Name of the table or view on
which the user has one or more
authorities
| | OWNER | CHAR | 20 | Owner of the table or view
on which the user has one or
more authorities
| | NCOL | INTEGER | 4 | Number of columns the user has
update authority on (0 if the
UPDATE column contains a Y)
| | NRCOL | INTEGER | 4 | Number of columns the user has
references authority on (0 if the REFERENCES column
contains a Y or N)
| | SELECT | CHAR | 2 | SELECT authority on the table or view: | | INSERT | CHAR | 2 | INSERT authority on the table or view: | | UPDATE | CHAR | 2 | UPDATE authority on the table
or view: - Y
for yes on all columns - N
for no on all columns - C
for yes on specific columns only
| | DELETE | CHAR | 2 | DELETE authority on the table
or view:
| | ALTER | CHAR | 2 | ALTER authority on the table
(for adding columns):
| | INDEX | CHAR | 2 | INDEX authority on the table
(for creating indexes):
- Y
for yes - N
for no or for a view
| | REFERENCES | CHAR | 2 | REFERENCES authority on the table (for
creating referential constraints that refer to this table):
- Y
for yes on all columns - N
for no on all columns or for a view - C
for yes on specific columns only
| | GRANTOR | CHAR | 20 | Name of the grantor of the privileges described in this row
or blank if column privileges have differing grantabilities
| | GRANTABLE | CHAR | 2 | GRANTABLE privilege on the table or view: - Y
for yes, the user can grant these privileges to others - N
for no, the user cannot grant these privileges to others - blank
if column privileges have differing grantabilities
|
Example | |
select * FROM System.Tabauth;
--------------------+--------------------+--------------------+-----------
USERID |NAME |OWNER |NCOL
--------------------+--------------------+--------------------+-----------
PUBLIC |PARTS |PURCHDB | 0
PUBLIC |INVENTORY |PURCHDB | 0
PUBLIC |SUPPLYPRICE |PURCHDB | 0
PUBLIC |VENDORS |PURCHDB | 0
PUBLIC |ORDERS |PURCHDB | 0
PUBLIC |ORDERITEMS |PURCHDB | 0
PUBLIC |MESSAGE |PURCHDB | 0
--------------------------------------------------------------------------
Number of rows selected is 7
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+-----------+------+------+------+------+-----+-----+----------+-------
|NRCOL |SELECT|INSERT|UPDATE|DELETE|ALTER|INDEX|REFERENCES|GRANTOR
+-----------+------+------+------+------+-----+-----+----------+-------
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
| 0|Y |Y |Y |Y |Y |Y |N |PURCHDB
---------------------------------------------------------------------------
Number of rows selected is 7
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]>r
+---------
|GRANTABLE
+---------
|N
|N
|N
|N
|N
|N
|N
|N
----------------------------------------
First 7 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
