-
Grants
Hi Everyone,
Someone has been messing with my grants: All users (even newly created ones) can see all tables and views, even the data dictionary.
A public synonym or a role enabling this doesn't seem to exist, so I'm looking for an sql query with which I can see all grants created within an instance.
Does anyone have such a script or can tell me in which system tables or views I can see grants?
Thanks
Peer
-
look dba_role_privs, dba_sys_privs
-
Thank you very much, just what I was looking for.
Bye
Peer
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
|