Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: glogin, on windows, affecting all sqlplus sessions.

Re: glogin, on windows, affecting all sqlplus sessions.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 3 Dec 2002 13:31:15 -0600
Message-ID: <uadjmc35z.fsf@standardandpoors.com>


On Tue, 3 Dec 2002, aammbuijs_at_xs4all.nl wrote:

> Just an idea: you could set up a glogin.sql on each Windows
> client machine when Oracle software is installed that calls a
> script in a common directory that is always available for all
> users and writable for authorised people only.

Right now, I am maintaining a glogin in source safe and I have everybody get the latest version of that to their $ORACLE_HOME/sqlplus/admin dir.

> You will have only 1 script to maintain for the entire
> environment. An alternative is to set up the SQLPATH registry
> key and include a common directory where login.sql can be
> found, but if users have access to the registry they could
> change it again.. as they can with the local glogin.sql
> probably.

If users want to bypass the glogin, there is not much I can do about it except get peeved when I find out.

-- 
Galen Boyer
Received on Tue Dec 03 2002 - 13:31:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US