Insufficient permission of accessing table from usrr-CodePudding

I have created table it's sequence on owner .

Also granted permission of insert update delete select on table from owner to user.

Also granted select on sequence from owner to user.

Finally I logged in user and created synonym for owner table and sequence.

Now when I access table in user it throws insufficient permission.the same table can be accessible in owner..

Any idea what I'm missing here..

CodePudding user response：

You should execute these queries and verify grantor and grant:

select * from all_tab_privs where table_name   ='YOUR_NAME_SEQUENCE';
select * from all_tab_privs where table_name   ='YOUR_NAME_TABLE';
select * from all_synonyms  where synonym_name ='YOUR_NAME_TABLE';

Certainly Grantor not equal to your user or some grant is missed.

Thank you.

CodePudding user response：

issue got resolved as issue with grant statement I gave incorrect user id