Home » RDBMS Server » Security » privs to see data in table outside user schema
privs to see data in table outside user schema [message #118539] Thu, 05 May 2005 15:01 Go to next message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
Which system privs would allow a user to see data in a table outside of the users own schema?

I know DBA and SELECT ANY TABLE will do it.
What else?

Trying to audit a schema to identify who has access to the tables.

Thanks

Report message to a moderator

Re: privs to see data in table outside user schema [message #118540 is a reply to message #118539] Thu, 05 May 2005 15:02 Go to previous message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
Forgot to ask ....
Does anyone have any suggestions of the best way to perform such an audit?

ie.
schema name ... system_app
Which users in the database can access data in system_app?

Report message to a moderator

Previous Topic: create package/trigger privileges
Next Topic: distructive user on my database....what should i do?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 28 17:28:57 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.