Re: monitor logins

From: Biju Thomas <bijuthomas_at_email.msn.com>
Date: Fri, 20 Nov 1998 23:28:17 -0600
Message-ID: <#m5WG$QF#GA.179@upnetnews05>

You can enable auditing on the database.

Set AUDIT_TRAIL=TRUE in the init.ora file and cycle the database.

Enable session auditing by "AUDIT SESSION;" command using SQL*Plus or SVRMGRL. To see the user logged info and other details, query the DBA_AUDIT_SESSION view.

--
Biju Thomas

For Oracle Scripts, Tips and Links
http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm

Naushi Hussain wrote in message <36559165.44AB_at_alliedsignal.com>...
>We need to track down our users on a server. Its a UNIX based Oracle 7.2
>(HP) server. Most users use the database through the browser. Very few
>have unix account.
>
>Is there a technique to find who are our users (we have lost track of
>them and we want to get rid of some of the applications on the server)
>and how often are they using the system
Received on Fri Nov 20 1998 - 23:28:17 CST