Re: authenticating user to Oracle - without supplying password

Home -> Community -> Usenet -> c.d.o.server -> Re: authenticating user to Oracle - without supplying password - Single sign on

From: Snewber <s_at_s.com>
Date: Tue, 2 Nov 2004 11:07:25 +1000
Message-ID: <cm6mkf$qkn$1@bunyip.cc.uq.edu.au>

Sorry, I should have taken the time to check it out in detail, instead of cutting and pasting.

The user is probably wondering why their code isn't working right now.

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2004.11.01.07.21.57.227464_at_sbcglobal.net...
> 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.
>
Received on Mon Nov 01 2004 - 19:07:25 CST