Good day.
Please explain the next issue
SQL> conn /as sysdba
Connected.
SQL> create user test identified by test;
User created.
SQL> create user test1 identified by test;
User created.
SQL> grant resource, connect to test;
Grant succeeded.
SQL> conn test
Enter password:
Connected.
SQL> create table t (x number);
Table created.
SQL> grant select on t to test1;
Grant succeeded.
SQL> conn /as sysdba
Connected.
SQL> grant select on test.t to scott;
Grant succeeded.
--########################---
SQL> select * from dba_tab_privs where table_name='T';
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
---------- ---------- ---------- ---------- -------------------- --- ---
SCOTT TEST T TEST SELECT NO NO
TEST1 TEST T TEST SELECT NO NO
SQL>
suppose that what has been above --########################--- - a black box.
How do you determine who is issued a grant???