0

Hi,

in oracle 10g express, I logged in system/HR.

I typed:
CREATE USER SHIPU IDENTIFIED BY SHIPU1.
click Run.

Then I typed,
GRANT SELECT, INSERT, UPDATE
ON EMPLOYEES TO SHIPU
WITH GRANT OPTION
click Run.

I logged out and logged back in as SHIPU/SHIPU1
I typed SELECT * FROM EMPLOYEES.
it says table does not exist.

Pls Advise.

Thanks.

3
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by bangla
1
SELECT * FROM HR.EMPLOYEES;

You don't have an EMPLOYEES table in the SHIPU Schema.
You have to give it a Schema reference (in this case HR.) or set up a Synonym to point to the HR.EMPLOYEES table.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.