dbTalk Databases Forums  

auditing status by user?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss auditing status by user? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mh@pixar.com
 
Posts: n/a

Default auditing status by user? - 04-09-2008 , 02:46 AM






We've got auditing enabled on a 10.2 database.

How can I find out a particular user's audit status, e.g.
what things are being audited for that user? Or a list
of users who have a particular auditing status?

I'm guessing there's a system table with this information but
I haven't been able to find it.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

Reply With Quote
  #2  
Old   
Mark D Powell
 
Posts: n/a

Default Re: auditing status by user? - 04-09-2008 , 12:51 PM






On Apr 9, 3:46*am, m... (AT) pixar (DOT) com wrote:
Quote:
We've got auditing enabled on a 10.2 database.

How can I find out a particular user's audit status, e.g.
what things are being audited for that user? *Or a list
of users who have a particular auditing status?

I'm guessing there's a system table with this information but
I haven't been able to find it.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios
Which audit view you look at depends on what commands you wish to
review, which in turn depends on what audit commands have been issued.

What commands were issued?

Generally you find out what is being audited by looking at

dba_priv_audit_opts
dba_stmt_audit_opts
dba_obj_audit_opts

HTH -- Mark D Powell --


Reply With Quote
  #3  
Old   
Mark D Powell
 
Posts: n/a

Default Re: auditing status by user? - 04-09-2008 , 12:51 PM



On Apr 9, 3:46*am, m... (AT) pixar (DOT) com wrote:
Quote:
We've got auditing enabled on a 10.2 database.

How can I find out a particular user's audit status, e.g.
what things are being audited for that user? *Or a list
of users who have a particular auditing status?

I'm guessing there's a system table with this information but
I haven't been able to find it.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios
Which audit view you look at depends on what commands you wish to
review, which in turn depends on what audit commands have been issued.

What commands were issued?

Generally you find out what is being audited by looking at

dba_priv_audit_opts
dba_stmt_audit_opts
dba_obj_audit_opts

HTH -- Mark D Powell --


Reply With Quote
  #4  
Old   
Mark D Powell
 
Posts: n/a

Default Re: auditing status by user? - 04-09-2008 , 12:51 PM



On Apr 9, 3:46*am, m... (AT) pixar (DOT) com wrote:
Quote:
We've got auditing enabled on a 10.2 database.

How can I find out a particular user's audit status, e.g.
what things are being audited for that user? *Or a list
of users who have a particular auditing status?

I'm guessing there's a system table with this information but
I haven't been able to find it.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios
Which audit view you look at depends on what commands you wish to
review, which in turn depends on what audit commands have been issued.

What commands were issued?

Generally you find out what is being audited by looking at

dba_priv_audit_opts
dba_stmt_audit_opts
dba_obj_audit_opts

HTH -- Mark D Powell --


Reply With Quote
  #5  
Old   
Mark D Powell
 
Posts: n/a

Default Re: auditing status by user? - 04-09-2008 , 12:51 PM



On Apr 9, 3:46*am, m... (AT) pixar (DOT) com wrote:
Quote:
We've got auditing enabled on a 10.2 database.

How can I find out a particular user's audit status, e.g.
what things are being audited for that user? *Or a list
of users who have a particular auditing status?

I'm guessing there's a system table with this information but
I haven't been able to find it.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios
Which audit view you look at depends on what commands you wish to
review, which in turn depends on what audit commands have been issued.

What commands were issued?

Generally you find out what is being audited by looking at

dba_priv_audit_opts
dba_stmt_audit_opts
dba_obj_audit_opts

HTH -- Mark D Powell --


Reply With Quote
  #6  
Old   
mh@pixar.com
 
Posts: n/a

Default Re: auditing status by user? - 04-10-2008 , 03:31 AM



Mark D Powell <Mark.Powell (AT) eds (DOT) com> wrote:
Quote:
Generally you find out what is being audited by looking at
[...]

HTH -- Mark D Powell --
yes it does... thanks a lot!

Mark

--
Mark Harrison
Pixar Animation Studios


Reply With Quote
  #7  
Old   
mh@pixar.com
 
Posts: n/a

Default Re: auditing status by user? - 04-10-2008 , 03:31 AM



Mark D Powell <Mark.Powell (AT) eds (DOT) com> wrote:
Quote:
Generally you find out what is being audited by looking at
[...]

HTH -- Mark D Powell --
yes it does... thanks a lot!

Mark

--
Mark Harrison
Pixar Animation Studios


Reply With Quote
  #8  
Old   
mh@pixar.com
 
Posts: n/a

Default Re: auditing status by user? - 04-10-2008 , 03:31 AM



Mark D Powell <Mark.Powell (AT) eds (DOT) com> wrote:
Quote:
Generally you find out what is being audited by looking at
[...]

HTH -- Mark D Powell --
yes it does... thanks a lot!

Mark

--
Mark Harrison
Pixar Animation Studios


Reply With Quote
  #9  
Old   
mh@pixar.com
 
Posts: n/a

Default Re: auditing status by user? - 04-10-2008 , 03:31 AM



Mark D Powell <Mark.Powell (AT) eds (DOT) com> wrote:
Quote:
Generally you find out what is being audited by looking at
[...]

HTH -- Mark D Powell --
yes it does... thanks a lot!

Mark

--
Mark Harrison
Pixar Animation Studios


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.