Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ids and passwords for application users

RE: Ids and passwords for application users

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 30 Jul 2002 16:53:20 -0800
Message-ID: <F001.004A6C3F.20020730165320@fatcity.com>


> -----Original Message-----
> From: groups_at_koovakattu.com [mailto:groups_at_koovakattu.com]
>
> If a common login is used (which is the case with most
> applications),
> dbms_application_info can be used to set the actual username
> in either the
> module or action. As long as the application is not using
> dbms_application_info
> to set both, you should be able to get the info from v$session.

Sure, but I will repeat what I said before: a) It's easier to write code if the user is determined by the Oracle userid rather than by
 v$session.client_info. Trigger example: create trigger orders_set_user
 before insert or update on orders
 for each row
begin

   :new.last_upd_user := user ;
end orders_set_user ;
/

b) How do you plan on hiding the password from the user, or, more importantly, changing the

   password if it becomes compromised?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 30 2002 - 19:53:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US