OraFAQ Forum: Server Administration » Database Directory permission

Home » RDBMS Server » Server Administration » Database Directory permission (Oracle 10g)

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

Database Directory permission [message #492971]

Fri, 04 February 2011 00:01

vnkumaresh
Messages: 9
Registered: December 2010

Junior Member

Hi,

My database is running in oracle 10g. I have more than 25 oracle directories which are being used for batch/reporting jobs.
I found read and write privileges are missing for 7 Dirs. I checked the last ddl time, it shows jan 26th.

I want know how to check which userid revoked it.

Please advice me.

Thanks

Report message to a moderator

Re: Database Directory permission [message #492973 is a reply to message #492971]

Fri, 04 February 2011 00:12

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you saying that there are MANY users who are powerful enough to create directories and grant / revoke privileges to work with?

Report message to a moderator

Re: Database Directory permission [message #492974 is a reply to message #492973]

Fri, 04 February 2011 00:17

vnkumaresh
Messages: 9
Registered: December 2010

Junior Member

Hi,

Yes, we do have few users have DBA privs on this DB.

Report message to a moderator

Re: Database Directory permission [message #492980 is a reply to message #492974]

Fri, 04 February 2011 00:52

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try to ask them?

Report message to a moderator

Re: Database Directory permission [message #492983 is a reply to message #492971]

Fri, 04 February 2011 01:08

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I want know how to check which userid revoked it.

Only one way: use Log Miner (good luck).

Now, for the future, activate AUDIT.

Regards
Michel

Report message to a moderator

Previous Topic:	password of an user
Next Topic:	Ifile in Manual DB creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 17:56:21 CDT 2024