Re: Auditing

Comments in-line.

Ed_Zep wrote:
> Hello. I'm looking into auditing the following:
>
> * successful/unsuccessful logins
> * multiple logins

Use system triggers. Demos of both of these functionalities can be found in Morgan's Library at www.psoug.org on the SYSTEM TRIGGERS page.

But why are you allowing multiple logins? Either create a new profile for your users, or alter the default profile, to disallow it.

> * schema changes

Again my instinct would be to prevent them rather than log them. But either way use DDL triggers. Also found in Morgan's Library.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org