What table contains Oracle Userid?

From: Bob McGuire <bmcguire_at_tiac.net>
Date: 1996/02/29
Message-ID: <4h346t$djl_at_sundog.tiac.net>#1/1


Greetings all.

Does anyone know what table, if any, contains the Oracle run Id? This would be the same one you see under SQLDBA in the user screen.

I've written a script that uses the spool command in the sqldba screen, but I'd rather have a recurring query.

Any Info greatly appreciated.

Thanks,

Bob Mc.

ps.. Thanks to all who responded to my question on the zip/unzip problem.

--
+-----------------------------------------------------+

| Bob McGuire, N1HKV ARRL/W5YI VE et al |
| Oracle Database Administrator/VMS Systems Manager |
| Groundwater Technology, Inc. Norwood, MA |
| Email to: bmcguire_at_gtionline.com |
| |
| "Testing's for sissies..." ...-.- |
-----------------------------------------------------+
Received on Thu Feb 29 1996 - 00:00:00 CET

Original text of this message