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