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