-
Privilege Issues
I have a user named ONE grant the table named TABLE to a role named MY_ROLE, and I turn around to grant MY_ROLE to another user named TWO. I also have a public and private synonym for the table named TABLE. I log in as the user named TWO and do a select on the synonym and it's telling me that the table does not exist.
what am I missing here????
-
Why do you have public and private synonyms? If it works for user ONE and does not work for user TWO , most likely private synonym for user TWO is not correct or does not exist.
-
Hi,
Try to use the schema-name.table-name ( connected as two --> select * from one.table ).
Gkramer