Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JANUARY FEBRUARY 2018 126 SQL connect as sysdba Connected SQL alter session set container bynd Session altered The SYS user grants the SQL_ 201 user the ability to pass on the object privilege SQL grant select on dba_ tables to sql_ 201 WITH GRANT OPTION Grant succeeded SQL connect sql_ 201@ bynd Enter password Connected This time the grant succeeds SQL grant select on dba_ tables to beyond_ 101 Grant succeeded SQL connect beyond_ 101@ bynd Enter password Connected Similarly now the BEYOND_ 101 user can query the DBA_ TABLES data dictionary view
You must have JavaScript enabled to view digital editions.