OraFAQ Forum: Security » privs to see data in table outside user schema

Home » RDBMS Server » Security » privs to see data in table outside user schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

privs to see data in table outside user schema [message #118539]

Thu, 05 May 2005 15:01

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 20:21:59 CST 2025