Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JANUARY FEBRUARY 2018 118 User created SQL GRANT CREATE SESSION CREATE TABLE 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 Listing 2 shows how the SQL_ 201 user grants the necessary object privilege to the BEYOND_ 101 user so that the query may succeed Note however that after the SQL_ 201 user has granted the SELECT object privilege for the EMPLOYEE table to the BEYOND_ 101 user when the BEYOND_ 101 user reattempts the query action the action results in the same error as that received in Listing 1 The same error takes place because in the absence of a synonym discussed later in this article each Oracle Database user must qualify the name of any object it does not own Listing 3 demonstrates how to qualify the name of the EMPLOYEE table so that the
You must have JavaScript enabled to view digital editions.