OraFAQ Forum: Security » Database security

Home » RDBMS Server » Security » Database security (oracle.10202,AIX)

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

Database security [message #310214]

Mon, 31 March 2008 10:29

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

Report message to a moderator

Re: Database security [message #310216 is a reply to message #310214]

Mon, 31 March 2008 10:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Describe with more details what you want.

Regards
Michel

Report message to a moderator

Re: Database security [message #311740 is a reply to message #310214]

Sun, 06 April 2008 07:15

kukreja
Messages: 33
Registered: February 2007

Member

Monto Try with joining dependences table with all_objects whose owner is sys to number of object

Report message to a moderator

Re: Database security [message #311742 is a reply to message #311740]

Sun, 06 April 2008 07:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator