Thursday, August 24, 2023

"ORA-00942 : table or view does not exist. " on synonym

"ORA-00942- table or view does not exist" error you are getting , this indicate that user1 does not have privileges on the user.test table (get the details from synonyms SQL which tables are included ) .


We need to grant that required privileges 


SQL> GRANT SELECT, INSERT, UPDATE, DELETE 

     ON USER.TEST 

     TO USER1;



Note : Create dynamic sql to refersh the privelige if multiple tables and schema included 

1 comment:

  1. save my life today :) , thank you vey much

    ReplyDelete

Interview Question 18 : What are oinstall and dba groups? Why we assign these groups to oracle user ?

  What are oinstall and dba groups in Oracle? Short answer oinstall → Controls software ownership and installation dba → Controls databa...