Home » RDBMS Server » Server Administration » Get a list of schemas which are able to update into objects under another user (10g, SUSE LINUX)
Get a list of schemas which are able to update into objects under another user [message #416681] Mon, 03 August 2009 22:44 Go to next message
*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.
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 Go to previous message
BlackSwan
Messages: 25043
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
Previous Topic: Miscellaneous Part in Shared Pool
Next Topic: Permission issues while using sql trace (merged)
Goto Forum:
  


Current Time: Wed Dec 07 08:35:19 CST 2016

Total time taken to generate the page: 0.13163 seconds