Auditing in 10.2B

[AbhayShukla]

Hello every one !!!!!!


I have enabled Auditing on my OE10.2B DB (windows XP) .
I have imported OE predefined policies and Activated
App-Schema
PSC-DB-Admin
Policies.

Please let me know how can i get reports on these audit policies where i can check who/when has created
table or start/stop DB.


i have read about aud-audit-data table and others but didn't get idea how to get audit data about DBAdmin activities (from PSC-DB-Admin policy).
an example may help me a lot.

Thanks.

 

[cj_brandt]

We have a user that can read the audit data tables and just write a report to display the info.

 

[AbhayShukla]

we r testing in uat , cant purchase......now .

 

[AbhayShukla]

Can anyone Guide me on this .....?????????

 

[TomBascom]

Your use case seems like something straight out of the docs.

Have you read the documentation? Is there something in particular that you don't understand? What have you tried that hasn't worked?

 

[AbhayShukla]

Docs r pathetic , a bit improved in 10.2 B.
As i have stated earlier , i am finding querying audit table difficult.
Just an example can show me light.

for example if i want to know that when was last table move(or any other DBA activity) done .
I have enabled App-Schema and PSC-Db-Admin policies.

thanks for ur replies..