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
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?
Previous Topic: create package/trigger privileges
Next Topic: distructive user on my database....what should i do?
Goto Forum:
  


Current Time: Fri Aug 14 21:19:51 CDT 2020