Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 Accessing an integer from a sequence not owned by the current database user Listing 1 re creates the BEYOND_ 101 user and demonstrates the result received when the user attempts to query the EMPLOYEE table Although the table exists in schema SQL_ 201 the query result is ORACLE MAGAZINE JANUARY FEBRUARY 2018 117 ORA 00942 table or view does not exist This error means that until the BEYOND_ 101 user has been granted the appropriate access for the object Oracle Database does not know that the table or view is an object upon which the BEYOND_ 101 user may perform actions This user must be granted the necessary object privilege from the tables owner Code Listing 1 A user must be granted query access to a database table the user does not own SQL set lines 60 SQL connect as sysdba Connected SQL alter session set container bynd Session altered SQL CREATE USER beyond_ 101 2 IDENTIFIED BY 201 3 DEFAULT TABLESPACE users 4 TEMPORARY TABLESPACE temp 5 QUOTA 100M ON USERS
You must have JavaScript enabled to view digital editions.