Wednesday, 15 June 2011

oracle - ORA-00942: table or view does not exist error is given even though I granted Select privilege to the user -



oracle - ORA-00942: table or view does not exist error is given even though I granted Select privilege to the user -

for oracle database created user. want user have access 3 tables. wrote queries:

grant select on table1 newuser; grant select on table2 newuser; grant select on table3 newuser;

and got console, ensures gave grant.

grant succeeded

however when connect database user , write next query, ora-00942 error.

select * table1;

i think need write additional queries privileges , roles(i added connect role). might be?

run query specifying table owner.

select * tableowner.table1;

if doesn't work either have not granted access on right table or logged in wrong user.

remember same table name can exist in multiple schemas.

oracle

No comments:

Post a Comment