User Privileges Problem.

[cpiyush]

Hi. I have just started working on Oracle. I am using Oracle9i.
Here is my problem: -

I have created a database through sysdba with 2-3 tables.
Then created a user 'demo' & granted all the privileges to 'demo' on tables.

Now When I logging in using demo account. & trying to access tables it is saying "Table or view doesn't exists".

Can You please tell me how to grant/use these privileges concept.

Thanks & Regards.

[wel]

here is juste an example to check if u've performed the right steps....


CONNECT / as sysdba;
--or anyone with the right privilege to create a user and assign the privileges
CREATE USER wel IDENTIFIED BY wel;
GRANT select ON demo.table TO wel;

CONNECT wel/wel
SELECT * FROM demo.table;

hope that we'll help you

[cpiyush]

Yeah Wel,

Thats worked.

Thanks.