RE:

From: McGlaughlin,Stewart <mcglaughlin_at_attws.com>
Date: Fri, 23 Jun 2000 10:14:26 -0400
Message-Id: <10537.110264@fatcity.com>

Sandy,

Check your listener.log file.
Use "lsnrctl status | grep log" to locate this file. Then grep <username> listener_log_location or to accomplish this with one command - try the following statement:

grep <username> `lsnrctl status | grep log | awk '{print $NF}'`

You may want to just change the password on the schema(s) - wait a week or so and then drop them. (just in case some does need the data)

HTH

---

Stewart McGlaughlin
Oracle DBA
On-site at AT&T Wireless Services
Oracle Links @ http://www.stewartmc.com/oracle stewartm_at_iname.com

> -----Original Message-----
> From: - DBA [SMTP:ora_dba_at_hotmail.com]
> Sent: Friday, June 23, 2000 9:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
>
> What is the simplest way to see when a user last connected to the
> database?
> We are trying to determine what schemas can be dropped and/or deactivated.
>
> Thanks.
> Sandy
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: - DBA
> INET: ora_dba_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jun 23 2000 - 09:14:26 CDT