oracle-databaseoracle19cdata-dictionary

Oracle data dictionary


Considering the following information from the Oracle data dictionary When the following command is executed, to obtain the information

SELECT grantee,owner,table_name,grantor, privilege, grantable
FROM user_tabs_privs;

enter image description here

What is the SQL statements that have been issued to cause these grants to exist in the dictionary? Also for each statement which user has executed the statement?


Solution

  • after you run the following steps, you can get the result you want

    (1) firstly login as Ann,run the SQL statement: grant select on project to Billy with grant option; (2) still as Ann, runt the SQL statement: grant delete on employee to marlam ; (3) login as Billy, run the SQL statement: grant select on project to leah ;