Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Changing password via stored procedure
You can accomplish this by using DBMS_DDL package.
Sharad
In article <70g049$9jg$1_at_bw107zhb.bluewin.ch>,
"Marc Rennhard" <rennhard.marc_at_mailsp.com> wrote:
> Hi there,
>
> I'm pretty new to ORACLE (7.3) and I'm writing my first stored procedures in
> PL/SQL. So just a question:
>
> How to change the password of a user via stored procedure?
> (It should correspond to ALTER USER user IDENTIFIED BY pwd)
>
> Thanks in advance for any help,
> Marc
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Oct 20 1998 - 00:00:00 CDT