Re: create logon trigger

From: DA Morgan <>
Date: Sat, 26 Apr 2008 16:05:16 -0700
Message-ID: <>

hpuxrac wrote:
> On Apr 26, 4:12 pm, Pedro Lopes <> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Apr 26 2008 - 18:05:16 CDT

Original text of this message