Error says table does not exist. My question is why do I get the error?
SQL> GRANT SELECT, INSERT, UPDATE, DELETE ON system.emp to chap7;
GRANT SELECT, INSERT, UPDATE, DELETE ON system.emp to chap7
*
ERROR at line 1:
ORA-00942: table or view does not exist
The table does exist,
SQL> select ename from emp;
ENAME
----------
KING
BLAKE
CLARK
JONES
MARTIN
ALLEN
TURNER
JAMES
WARD
FORD
SMITH
ENAME
----------
SCOTT
ADAMS
MILLER
Stuttle
15 rows selected.
Perhaps the
EMP
table isn't owned bySYSTEM
? Do:Also, what user are you doing the
GRANT
andSELECT
as?