Re: create logon trigger
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 27 Apr 2008 14:35:02 GMT
Message-ID: <48148f16$0$6432$834e42db@reader.greatnowhere.com>
Date: 27 Apr 2008 14:35:02 GMT
Message-ID: <48148f16$0$6432$834e42db@reader.greatnowhere.com>
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
-- http://mgogala.freehostia.comReceived on Sun Apr 27 2008 - 09:35:02 CDT