|
-
The synonym has nothing to do with privileges on the undelying object, even if there is a public synonym if the user does not have either explict privileges or privileges granted via a role they will not be able to read the contents of the table.
If you can still select from the table, I would suggest that you look carefully at the privileges assigned to the role and to the user.
HTH
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|