您好,登录后才能下订单哦!
这篇文章将为大家详细讲解有关ORACLE ERP如何修改密码,小编觉得挺实用的,因此分享给大家做个参考,希望大家阅读完这篇文章后可以有所收获。
首先ERP的用户分两大类,应用用户、数据库用户;其中数据库用户又分两类,ERP相关的、ERP无关的
应用用户:WEB页面的登录用户如sysadmin、asadmin
ERP相关的数据库用户:如APPS、AK、IBC这些
ERP无关的数据库用户:如system或单纯使用sqlplus>create user username的
数据库中查询和和ERP无关的数据库用户
select * from dba_users where username not in(select APPLICATION_SHORT_NAME from APPS.FND_APPLICATION_VL) and account_status='OPEN' order by user_id desc
或
select * from dba_users where username not in(select ORACLE_USERNAME from APPS.fnd_oracle_userid) and account_status='OPEN' order by user_id desc
不过貌似下面这个是对的,因为查出的ABM居然不受FNDCPASS ALLORACLE修改密码的影响
su - oracle
sqlplus / as sysdba
alter user system identified by manager01;
su -applmgr
FNDCPASS apps/123456 0 Y system/manager01 user 101004871 PwD20180207
--修改ERP WEB登录界面用户101004871的密码为PwD20180207
--apps的密码为123456,system的密码为manager01
FNDCPASS apps/123456 0 Y system/manager01 SYSTEM APPLSYS apps
--修改apps和applsys的密码为apps,apps原来的密码是123456
FNDCPASS apps/apps 0 Y system/manager01 ALLORACLE apps
--修改所有和ERP相关的数据库用户的密码为apps
FNDCPASS apps/apps 0 Y system/manager01 oracle hwms 666666
--单独修改和ERP相关的数据库用户hwms的密码为666666
--如果该数据库用户和ERP不相关,会报错如APP-FND-02702: XX is not a valid oracle user.
To change an Oracle E-Business Suite user's password:
You can use this command to change an individual Oracle E-Business Suite user's password.
FNDCPASS 0 Y USER
For example, if you were changing the password for the user VISION to 'WELCOME', you would use the following command:
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
logon The Oracle username/password.
system/password The username and password for the System DBA account.
username The Oracle E-Business Suite username. For example, 'VISION'.
new_password The new password
To change the APPS and APPLSYS (type 2) schema password:
Use this command to change passwords for schemas that are used by shared components of Oracle E-Business Suite.
FNDCPASS 0 Y SYSTEM
For example, the following command changes the APPLSYS password to 'WELCOME'.
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
logonThe Oracle username/password.
system/passwordThe username and password for the SYSTEM DBA account.
usernameThe APPLSYS username. For example, 'applsys'.
new_passwordThe new password.
--以上命令看起来是修改applsys,其实apps和applsys一起都修改了
关于“ORACLE ERP如何修改密码”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,使各位可以学到更多知识,如果觉得文章不错,请把它分享出去让更多的人看到。
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。