Oracle Apps R12 Change sysadmin password from sqlplus
Two methods to change the
sysadmin password:
1- CPASS tool: This is an Oracle tool that allow change system and database user password's
like SYSADMIN, APPLSYSPUB, APPS, GL, AR.
FNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN newspassword
2- fnd_user_pkg tool: This package maintains oracle application user accounts
To change the sysadmin password execute the following script:
declare
l_flag boolean;
begin
l_flag = fnd_user_pkg.change_password('sysadmin','newpassword');
end;
To check if the new password take place run the following:
select fnd_web_sec.validate_login('sysadmin','newpassword') from dual;
The expected result would be Y.
1- CPASS tool: This is an Oracle tool that allow change system and database user password's
like SYSADMIN, APPLSYSPUB, APPS, GL, AR.
FNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN newspassword
2- fnd_user_pkg tool: This package maintains oracle application user accounts
To change the sysadmin password execute the following script:
declare
l_flag boolean;
begin
l_flag = fnd_user_pkg.change_password('sysadmin','newpassword');
end;
To check if the new password take place run the following:
select fnd_web_sec.validate_login('sysadmin','newpassword') from dual;
The expected result would be Y.
No comments:
Post a Comment