SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYNONYM - insufficient privileges error

731171Jul 16 2010 — edited Jul 16 2010

Hi,

I am having two users on my database.

INTCHG
CENTRAL

and tables in the users

INTCHG
INTCHG_TAB1 - TABLE
SEQ1 - SEQUENCE

CENTRAL
CENTRAL_TAB1 - TABLE
CENTRAL_TAB2 - TABLE

I have created two SYNONYM to access CENTRAL tables.
CENTRAL_TAB1 - Grants [insert]
CENTRAL_TAB2 - Grants [select]

i am having procedure on INTCHG user where i am inserting data into CENTRAL_TAB1 synonym.

inserting into CENTRAL_TAB1 synonym
sequence SEQ1 used in select clause
synonym CENTRAL_TAB2 using for JOIN with INTCHG_TAB1 in WHERE clause

i trying to execute procedure it is giving insufficient privileges.

Regards,
Tushar Joshi

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2010

Added on Jul 16 2010

7 comments

1,648 views