InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
A User Is Getting An Ora-00942 Error Yet You Know You Have Granted Them Permission On The Table, What Else Should You Check? |
|
Answer» You need to check that the USER has specified the FULL NAME of the object (SELECT empid FROM scott.EMP; instead of SELECT empid FROM emp;) or has a synonym that points to the object (CREATE SYNONYM emp FOR scott.emp;). You need to check that the user has specified the full name of the object (SELECT empid FROM scott.emp; instead of SELECT empid FROM emp;) or has a synonym that points to the object (CREATE SYNONYM emp FOR scott.emp;). |
|