Re: authenticating user to Oracle - without supplying password - Single sign on

On Mon, 01 Nov 2004 10:26:55 +1000, Snewber wrote:

> I would think about using a log on trigger to check sys_context information
> such as some of the following:
>
> select
> SYS_CONTEXT('USERENV','TERMINAL') terminal,
> SYS_CONTEXT('USERENV','LANGUAGE') language,
> SYS_CONTEXT('USERENV','SESSIONID') sessionid,
> SYS_CONTEXT('USERENV','INSTANCE') instance,
> SYS_CONTEXT('USERENV','ENTRYID') entryid,

And how exactly would he do that if he cannot connect to Oracle? Oracle*Net so far doesn't support telepatic connections. That will be in available the Oracle 13, which will be announced on Friday the 13th in September 2013.

-- 
Artificial Intelligence is no match for natural stupidity.