Tuesday, September 19, 2006 |
Reset the password of an Oracle user |
Forgot your password, dont get irritated, with the following convenient password reset procedure found in a large production database, with EXECUTE granted to PUBLIC and a handy public synonym:
CREATE OR REPLACE PROCEDURE reset_user_password(p_username IN VARCHAR2) AS BEGIN execute immediate 'ALTER USER '||upper(p_username)||' IDENTIFIED BY '||upper(p_username); END; |
Published by Aneesh @ 11:15 PM |
|
|
|
About Me |
|
Last Entries |
|
Archieves |
|
Link |
Shoutbox |
PUT HERE |
Title |
EDIT HERE |
Designed By |
|
Google Adsense |
|
Credit |
Pro Blogger Template |
|