OraFAQ Forum: Server Administration » Get a list of schemas which are able to update into objects under another user

Home » RDBMS Server » Server Administration » Get a list of schemas which are able to update into objects under another user (10g, SUSE LINUX)

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

Get a list of schemas which are able to update into objects under another user [message #416681]

Mon, 03 August 2009 22:44

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi all,

I'm in the midst of collecting the infor on which users are able to update into objects under user - ABC.

We have around 150 schemas under this database. Other than checking dba_ts_quotas, we should check object privilege assiged, correct me if i'm wrong.

How could we spool a list of the data? Or we have no alternatives than checking schemas by schemas?

Thank you.

Report message to a moderator

Re: Get a list of schemas which are able to update into objects under another user [message #416683 is a reply to message #416681]

Mon, 03 August 2009 22:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> How could we spool a list of the data?
SQL> SPOOL results.lis

>Or we have no alternatives than checking schemas by schemas?
I doubt you'll find the details you desire in the application schemas.

One or more of the views below contain details concerning who can access what in this instance

DBA_AQ_AGENT_PRIVS
DBA_COL_PRIVS
DBA_PRIV_AUDIT_OPTS
DBA_REPGROUP_PRIVILEGES
DBA_ROLE_PRIVS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DBA_RSRC_MANAGER_SYSTEM_PRIVS
DBA_SYS_PRIVS
DBA_TAB_PRIVS
DBA_WM_SYS_PRIVS
DBA_WORKSPACE_PRIVS

Report message to a moderator

Previous Topic:	Miscellaneous Part in Shared Pool
Next Topic:	Permission issues while using sql trace (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 23 07:09:50 CDT 2026