Tony,
If I follow your explaination correctly you would like
USER-A to be able to unlock Oracle userid's, change them, and or expire the
USER-B password rather that have the DBA perform the function.
You could GRANT ALTER USER to USER-B: then USER-B can change
the passwords for other users plus a host of other things;
ROR mª¿ªm>>> tbarker_at_doit.state.in.us
01/10/02 02:15PM >>>We have an application that is using Oracle
user-ids and passwords forauthentication and restrictions. I am
looking for a secured, selective,user-interface way of unlocking, resetting
and expiring passwords so the DBAstaff can offload this rather mundane but
frequent requests. I would liketo do it through an oracle stored
procedure where the user-id and passwordwould be provided by a authorized
user and the stored procedure wouldunlock, change the password, and expire
the user. Is this possible or is it much easier to use a Unix
script?Thanks in advance for the
suggestions!!!+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~Tony
Barker - Senior DBA - State of
Indiana+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~(317)
232-0719
tbarker_at_doit.state.in.us-- Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Barker,
Tony INET: tbarker_at_doit.state.in.usFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Thu Jan 10 2002 - 14:15:29 CST
