Re: create logon trigger

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 27 Apr 2008 10:05:19 -0700
Message-ID: <1209315916.887987@bubbleator.drizzle.com>


Mladen Gogala wrote:
> On Fri, 25 Apr 2008 13:52:34 -0700, emdproduction wrote:
>

>> I want to maintain a table, so that if people in this table, they can
>> logon using sqlplus, if they are not, they can only logon through our
>> application server.

>
> Look at the PRODUCT_USER_PROFILE table. It's very simple, explained
> here:
> http://www.idevelopment.info/data/Oracle/DBA_tips/Security/SEC_1.shtml

Good thought ... and there is a working demo here: http://www.psoug.org/reference/pup.html

-- 
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.org
Received on Sun Apr 27 2008 - 12:05:19 CDT

Original text of this message