I assume that the password policy is enforced through a profile

You should write a script that changes the PASSWORD_VERIFY_FUNCTION resource for the user profile to unlimited, issue the alter user identified by desired_password command, and then return the PASSWORD_VERIFY_FUNCTION resource to its appropriate value for password verification.

Good luck,



Aryeh Keefe



-----Original Message-----
From: Cox, Nick [mailto:Nick.[Email Address Removed]
Sent: ו 30/01/2004 15:11
To: LazyDBA.com Discussion
Cc:
Subject: urgent - is there any way to circumvent password policy



I need to reset a p/w back to it's original setting.

We have a p/w policy in place which prevents reuse of passwords - which is
great until a helpdesk user changes a password in the wrong database ...

Is there an easy way to do this ?

cheers,

Nick.





Nick Cox
Database Infrastructure
Sherborne House, 119-121 Cannon Street, London. EC4N 5AT.
Tel: + 44 (0) 20 7653 7096 Direct
Tel: + 44 (0) 20 7653 7699 Database Support Hotline
Tel: + 44 (0) 7713 790628 Mobile
Fax: + 44 (0) 207 984 0270







**********************************************************************
This is a commercial communication from Commerzbank AG.

This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.

Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.

This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.

**********************************************************************






**************************************************************************************************
This e-mail message has been sent by Team Computer and Systems Ltd. and is for the
use of the intended recipients only. This document may contain confidential,
commercial and privileged information or data that constitute proprietary information of
TEAM Computers & Systems. Any review or distribution by others is strictly prohibited.
If you are not the intended recipient you are hereby notified that any use of this
information or data by any other person is absolutely prohibited and your repuested to
delete the e-mail and notify the sender immediately. Thank You.
**************************************************************************************************

** eSafe scanned this email for viruses, vandals and malicious content **


Oracle LazyDBA home page