Home » RDBMS Server » Security » Database security (oracle.10202,AIX)
Database security [message #310214] Mon, 31 March 2008 10:29 Go to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Hi ,
I need to write a query for pulling out the following info,can anybody help me out with this.

# of objects with access to system objects granted directly

Thanks
Re: Database security [message #310216 is a reply to message #310214] Mon, 31 March 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Describe with more details what you want.

Regards
Michel
Re: Database security [message #311740 is a reply to message #310214] Sun, 06 April 2008 07:15 Go to previous messageGo to next message
kukreja
Messages: 33
Registered: February 2007
Member
Monto Try with joining dependences table with all_objects whose owner is sys to number of object
Re: Database security [message #311742 is a reply to message #311740] Sun, 06 April 2008 07:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can give any answer without knowing the question.
Your answer may be useful or plain wrong, it depends on the question OP did not precise.
In addition, if OP did not answer to my question, I doubt he cares of your answer.

Regards
Michel
Re: Database security [message #311758 is a reply to message #310214] Sun, 06 April 2008 11:28 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Thanks everyone,got it from dba_dependencies.

Regards
Re: Database security [message #311765 is a reply to message #311758] Sun, 06 April 2008 12:23 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Glad you found your answer, it would be better if you'd better explain what you want.
Maybe the next time...

Regards
Michel
Previous Topic: Grant restriction
Next Topic: Insufficient privileges Problem
Goto Forum:
  


Current Time: Thu Mar 28 13:08:18 CDT 2024