SYSTEMTABAUTH :
COLUMN
username ,
grantor ,
tname ,
owner tname
selauth SELECT
insauth INSERT
delauth DELETE
( auth) Y, N, G. G , . , N ( , - ).
=============== SQL Execution Log ================
| SELECT username, dba |
| FROM SYSTEMUSERAUTH |
| WHERE resource = 'Y' |
|; |
| ================================================= |
| username dba |
| ----------- ------ |
| Diane N |
| Adrian Y |
===================================================
24.5. RESOURCE
. tname, - ( , ), (), . ( ), .
UPDATE REFERENCES , , . , , . .
SELECT, INSERT DELETE, Adrian , ( 24.6):
SELECT username, selauth, insauth, delauth
FROM SYSTEMTABAUTH
WHERE grantor = 'Adrian' AND tname = 'Customers';
=============== SQL Execution Log ================
| SELECT username, selauth, insauth, delauth |
| FROM SYSTEMTABAUTH |
| WHERE grantor = 'Adrian' |
| AND tname = 'Customers' |
|; |
| ================================================= |
| username selauth insauth delauth |
| ----------- ------- -------- -------- |
| Claire G Y N |
| Norman Y Y Y |
===================================================
24.6. Adrian
, Adrian Claire INSERT SELECT , . Norman SELECT, INSERT DELETE, . Claire DELETE - , .
|
|
SYSTEMCOLAUTH
username
grantor
tname
cname
owner tname
updauth UPDATE
refauth REFERENCES
updauth refauth Y, N, G; N . , . SYSTEMTABAUTH cname, . .
SYSTEMTABAUTH .
, REFERENCES, ( 24.7)
SELECT owner, tname, cname
FROM SYSTEMCOLAUTH
WHERE refauth IN ('Y', 'G') AND username = USER
ORDER BY 1, 2;
, , , , , (.. ).
=============== SQL Execution Log ================
| SELECT OWNER, TNAME, CNAME |
| FROM SYSTEMCOLAUTH |
| WHERE refaulth IN ('Y', 'G') |
| AND username = USER |
| ORDER BY 1, 2 |
|; |
| ================================================= |
| owner tname cname |
| ----------- ----------- ------- |
| Diane Customers cnum |
| Diane Salespeople sname |
| Diane Salespeople sname |
| Gillan Customers cnum |
===================================================
24.7. INSERT