Home » RDBMS Server » Security » auditing is not working (merged)
auditing is not working (merged) [message #376139] Tue, 16 December 2008 04:39 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi.

Auditing is not working after all changes.

I have set AUDIT_TRAIL=DB and AUDIT_SYS_OPERATIONS=TRUE. I have bounced the database . I created a table and updated using other user login. But auditing is now working.

Below are the auditing queries.

audit all by access;

audit select table,update table,insert table,delete table by access;

SQL> select count(*) from dba_audit_trail;

COUNT(*)
----------
0

Pls assit..
Re: auditing is not working (merged) [message #376144 is a reply to message #376139] Tue, 16 December 2008 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing prove in your post you make any audited statement.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and copy and paste your session.

Don't multipost your questions.

Regards
Michel
Re: auditing is not working (merged) [message #376452 is a reply to message #376144] Wed, 17 December 2008 07:00 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi the sql formatter formatting the below sql queries working for

audit all by access;

audit select table,update table,insert table,delete table by access;

But its sql query. it worked for me previously in other databases. but its not working new database that i created.
Re: auditing is not working (merged) [message #376455 is a reply to message #376452] Wed, 17 December 2008 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question

Regards
Michel
Re: auditing is not working (merged) [message #376461 is a reply to message #376455] Wed, 17 December 2008 07:32 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member


Sorry,

The sql formatter in SQL Formatter does not works for the below sql queries.

Quote:
audit all by access;

audit select table,update table,insert table,delete table by access;



But the above scripts are the sql queries that worked previously..
Re: auditing is not working (merged) [message #376463 is a reply to message #376461] Wed, 17 December 2008 07:37 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You concentrate on a detail of my post, a general remark.
The most important point is:
Quote:
Nothing prove in your post you make any audited statement.

And then:
Quote:
Use SQL*Plus and copy and paste your session.

Regards
Michel

Previous Topic: password creation in oracle 10g
Next Topic: Need a encrypt a column data
Goto Forum:
  


Current Time: Thu Mar 28 11:51:46 CDT 2024