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.

Member Avatar

hfx642

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.

You granted from which schema system or HR ?

Thanks hfx642
it works.