Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 BEYOND_ 101 user may successfully query it To qualify the name of an object you provide the schema name and the object name separated by the period character for example SQL_ 201 EMPLOYEE Code Listing 2 The SQL_ 201 user grants the SELECT object privilege for the EMPLOYEE table to the BEYOND_ 101 user SQL connect sql_ 201@ bynd Enter password Connected ORACLE MAGAZINE JANUARY FEBRUARY 2018 119 SQL grant select on employee to beyond_ 101 Grant succeeded SQL connect beyond_ 101@ bynd Enter password Connected SQL select first_ name last_ name 2 from employee 3 order by last_ name from employee ERROR at line 2 ORA 00942 table or view does not exist
You must have JavaScript enabled to view digital editions.