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.

Recommended Answers

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.

Jump to Post

All 3 Replies

Member Avatar
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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.