OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Access Logs via SQL (Oracle 11g R2)

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

Access Logs via SQL [message #515943]

Thu, 14 July 2011 05:06

aucrun
Messages: 114
Registered: February 2011

Senior Member

Hi,

I'm currently working on a project in which I do not have permissions to access the Server where the database is installed and configure.
Because of company policies, I do not have Admin Rights over Oracle, but I do have an account that can make Selects to DBA_USER_PRIVS for instance.

I would like to know if there is any way to access the database logs to know if there was any kind of problem within the database, because one of my Schemas misteriously went clean (all tables, sequences, triggers, ... vanished)

Can anyone help me, please?

Thanks!

Report message to a moderator

Re: Access Logs via SQL [message #515947 is a reply to message #515943]

Thu, 14 July 2011 05:17

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you mean the alert_log you could always try creating an external table on it.

Report message to a moderator

Re: Access Logs via SQL [message #515956 is a reply to message #515947]

Thu, 14 July 2011 05:27

aucrun
Messages: 114
Registered: February 2011

Senior Member

But how can I find the Alert_logs.txt file?

I don't have access to the fileserver.

Is there any other way?

Report message to a moderator

Re: Access Logs via SQL [message #515957 is a reply to message #515943]

Thu, 14 July 2011 05:29

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

Senior Member
Account Moderator

If you have no access to the database server then you can't.
(Anyway such action is not in alert.log)

If there is an audit on ddl (which is often the case on production) then query dba_audit_trail.
Otherwise, you have to ask the DBA to make the investigation for you, maybe using Log Miner.

Regards$
Michel

Report message to a moderator

Re: Access Logs via SQL [message #515962 is a reply to message #515957]

Thu, 14 July 2011 05:39

aucrun
Messages: 114
Registered: February 2011

Senior Member

Thanks!

Since I don't have the SYS password, I will wait for my DBA to find what has happening.

Thanks a lot!

Report message to a moderator

Previous Topic:	Not able to gather Statistics of neither schema nor table
Next Topic:	NLS_COMP and NLS_SORT (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:57:21 CST 2024