Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tracking when a user logs in.

Re: Tracking when a user logs in.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Mon, 20 Aug 2001 20:07:19 GMT
Message-ID: <3b816deb.952819937@news.alt.net>


On Mon, 20 Aug 2001 21:45:11 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"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
>
>
>

Got it
<URL:http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/audit.htm>. Thanx.

Brian Received on Mon Aug 20 2001 - 15:07:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US