Re: create logon trigger
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 26 Apr 2008 16:05:16 -0700
Message-ID: <1209251114.883502@bubbleator.drizzle.com>
>
> It sounds like you are also hinting around at my question ... why
> create an oracle table of IP addresses unless the whole organization
> is static and people always use the same workstation.
Date: Sat, 26 Apr 2008 16:05:16 -0700
Message-ID: <1209251114.883502@bubbleator.drizzle.com>
hpuxrac wrote:
> On Apr 26, 4:12 pm, Pedro Lopes <pedro.lo..._at_netvisao.pt> wrote:
>
> snip
>
>> Can't the SET ROLE be made at the application level ? >> That way only ppl coming from the application (application server) would >> have the role to login. >>
>
> It sounds like you are also hinting around at my question ... why
> create an oracle table of IP addresses unless the whole organization
> is static and people always use the same workstation.
In some security conscious organizations that is the norm. A person with valid userid and password, not sitting at "their" desk during normal business hours is not allowed access.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Apr 26 2008 - 18:05:16 CDT