Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JANUARY FEBRUARY 2018 125 Enter password Connected SQL select table_ name 2 from dba_ tables 3 where owner SQL_ 201 4 order by table_ name TABLE_ NAME ANNUAL_ REVIEW DEPARTMENT EMPLOYEE EMPLOYEE_ CTAS EMPLOYEE_ EXTRA EMPLOYEE_ IDENTITY EMPLOYEE_ SUBSET 7 rows selected The SQL_ 201 user has been granted query access but cannot yet pass it on SQL grant select on dba_ tables to beyond_ 101 grant select on dba_ tables to beyond_ 101 ERROR at line 1 ORA 01031 insufficient privileges
You must have JavaScript enabled to view digital editions.