-
Revoking privledge on a synonym
Good Morning Gurus.
Am setting up a restricted role but have hit a snag in that there are a few public synonyms that point to objects I don't want the role to see. Have not found a way yet to revoke the select privledge via this synonym. I have revoked ALL on the object in question to the user and the role, but they can still DESC and SELECT from the object.
Any thoughts?
Tks
Bob
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
|