/* This is sample script to re-set an FND User password from database. Need to connect as an APPS schema user. */
set serverout on;
set verify off;
declare
a varchar2(100):='&UserName';
b varchar2(100):='&password';
BEGIN
if a is not null and b is not null then
IF FND_USER_PKG.ispasswordchangeable(a) THEN
DBMS_OUTPUT.put_line('Setting user '||a||' with password '||b);
IF FND_USER_PKG.changePassword(a,b) THEN
DBMS_OUTPUT.put_line('Sucess');
ELSE
DBMS_OUTPUT.put_line('Failed');
END IF;
ELSE
DBMS_OUTPUT.put_line('The user password cannot be re-set as its unchangeable');
END IF;
END IF;
END;
/
Building an FMW Cluster using Docker (Part III Running Docker Containers)
-
Click here for a Google Docs version of this document that doesn't suffer
from the Oracle blog formatting problems
Oracle Fusion Middleware Deployment...
7 years ago