Re: Who is logged in?

>Bob B wrote:
>
>> Is there a simple way to tell who is using the database
>> when I want to shut it down?
>>

Usually the v$session OSUSER column contains the operating system userid of the client. On Unix it will be the name of the Unix userid and with Windows the NetBIOS name of the PC.

If you're running a NT backend with only Windows clients, you probably can send an automatic warning to all the users connected. The NET command on NT has a message parameter which enables you to send a message to a specific NetBIOS machine (or all the machines in a NT domain). I can recall the exact parameters, but it is something like NET SEND <nbname> <message>. You should be able to create a NT CMD file containing the these commands from a SQL*Plus script.

The only problem is that the WinPopup utility must be running on the Windows client to receive the message. This was aactive by default with WFW 3.11, but not with Win95. So you'll need to autostart it via the Startup program folders on the clients.

regards,
Billy Received on Fri Feb 20 1998 - 00:00:00 CST