We had better to query USER_TABLES to list all tables that belongs to current user SH for sure. Without schema name prefixed, SQL parser will search for the table in the scope of current user, SH. Why is ORA-00942? Haven't we been granted to access the table? This is because we forgot to prefix schema name. Select first_name from employees where last_name = 'Chen' SQL> select first_name from employees where last_name = 'Chen' SQL> conn hr/hrĪs the user SH, we tried to query the table. No, not such thing.įirst of all, we granted SELECT privilege on a table EMPLOYEES of HR to SH, which means SH can query EMPLOYEES even though it does not belong to him.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |