Re: Logons & V$SESSION

From: Jens Kieffer-Olsen <dstdba_at_post4.tele.dk>
Date: 1998/10/21
Message-ID: <70l54k$ida$1@dalen.get2net.dk>#1/1

Roy Jones wrote in message <362bb7c2.5631756_at_news1.lig.bellsouth.net>...
>I have a question about logging into the database:
>
>I have an ORACLE 7.3.4.1 database running on an HP9000 K410/570.
>We want to allow our users to log on with only a certain set of tools.
>My first attempt was to monitor the V$SESSION table specifically the
>PROGRAM column to determine what tool is being logged in with. This
>works great for all situations except Windows NT. WinNT put the full
>path to the program/shortcut in the table which normally is more than
>the 48 characters the PROGRAM column can handle.
>My next attempt was to go back to the PRODUCT_USER_PROFILE table but
>all I know about it is that you must list each product individually
>and the only valid value I know is SQL*Plus.
>
>Any and all help would be greatly appreciated.

For one thing the PROGRAM column handles 64 characters!

--
Jens Kieffer-Olsen

Received on Wed Oct 21 1998 - 00:00:00 CDT