Home » RDBMS Server » Server Administration » Access Logs via SQL (Oracle 11g R2)
Access Logs via SQL [message #515943] Thu, 14 July 2011 05:06 Go to next message
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!
Re: Access Logs via SQL [message #515947 is a reply to message #515943] Thu, 14 July 2011 05:17 Go to previous messageGo to next message
cookiemonster
Messages: 10904
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you mean the alert_log you could always try creating an external table on it.
Re: Access Logs via SQL [message #515956 is a reply to message #515947] Thu, 14 July 2011 05:27 Go to previous messageGo to next message
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?
Re: Access Logs via SQL [message #515957 is a reply to message #515943] Thu, 14 July 2011 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58860
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Access Logs via SQL [message #515962 is a reply to message #515957] Thu, 14 July 2011 05:39 Go to previous message
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!
Previous Topic: Not able to gather Statistics of neither schema nor table
Next Topic: NLS_COMP and NLS_SORT (merged)
Goto Forum:
  


Current Time: Fri Aug 22 03:14:33 CDT 2014

Total time taken to generate the page: 0.05736 seconds