Re: Need procedure to change password
Date: 1996/03/17
Message-ID: <4ii7v3$ao5_at_gossamer.itmel.bhp.com.au>#1/1
In article <4i7v8m$igp_at_gaia.cc.gatech.edu>, badri (badri_at_cc.gatech.edu)
says...
>
>Hi:
>
> I need the equivalent of a setuid script on UNIX. I want
>an operator to maintain passwords of the hundreds of users we are
>going to have soon. This operator would execute a procedure
>that would take a username and passwd as arguments and alter that
>user. The operator would obviously not be able to change the password
>of sys. The id for that operator would only have execute procedure on
this
>procedure and nothing else.
>
> I created a procedure, but PL/SQL does not like ALTER inside
>a procedure. Looks like I cannot issue such commands from a procedure.
>How do I get this done?
>
>Haaaaaaalp,
>
>-Badri
Oracle has a technical bulletin which covers this - ask them for
Technical Bulletin 106790.299
It fully describes it, and I have implmented it
(after you fix the bugs (I think, from memory - its been a while),
and 'improve' it properly)
HIH
Lee
----------------+---------------------------------------------------
This | Lee Levy, ISSD Systems Development, Del Code (34)
space | BHP Information Technology, ACN 006 476 213
left blank | PO Box 261, Warrawong, NSW 2502, Australia
intentionally | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
in mourning | Internet : levy.lee.ls_at_bhp.com.au
----------------+---------------------------------------------------Opinions expressed are mostly my own, so give me some credit. Received on Sun Mar 17 1996 - 00:00:00 CET