Re: Tracking when a user logs in.

If you're using 8.1.x --- you can also create a trigger to populate a table (that you can query later) when a use logs in.

Alex
Oracle/SQL DBA

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:to2q6kjkfnig19_at_news.demon.nl...
>
> "Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote
in
> message news:3b81641c.950308265_at_news.alt.net...
> > I have a user in the database, that should not be logging in too
> > often. There is no set time for the logins, but I'd like to track the
> > logins and what queries are being run.
> >
> > Currently, I login and check that manually. I would like to automate a
> > reporting, such as who, from where, logon time, logoff time, and
> > possibly the queries.
> >
> > Does someone have a method to do this? If a trigger did this, what
> > rights would it need?
> >
> > Brian
>
> You are referring to the audit facility present in Oracle since the early
> days of v6
> Just set init.ora's audit_trail to true
> bounce the database
> and start issuing audit statements.
> Apart from the queries (you can audit them, but it will deteriorate
> performance) you can get all the info you require by issuing a simple
audit
> connect
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Tue Aug 21 2001 - 00:32:00 CDT