ORACLE ERP如何修改密碼

這篇文章將為大家詳細(xì)講解有關(guān)ORACLE ERP如何修改密碼，小編覺(jué)得挺實(shí)用的，因此分享給大家做個(gè)參考，希望大家閱讀完這篇文章后可以有所收獲。

首先ERP的用戶分兩大類，應(yīng)用用戶、數(shù)據(jù)庫(kù)用戶；其中數(shù)據(jù)庫(kù)用戶又分兩類，ERP相關(guān)的、ERP無(wú)關(guān)的

應(yīng)用用戶:WEB頁(yè)面的登錄用戶如sysadmin、asadmin
ERP相關(guān)的數(shù)據(jù)庫(kù)用戶：如APPS、AK、IBC這些
ERP無(wú)關(guān)的數(shù)據(jù)庫(kù)用戶：如system或單純使用sqlplus>create user username的

數(shù)據(jù)庫(kù)中查詢和和ERP無(wú)關(guān)的數(shù)據(jù)庫(kù)用戶
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
不過(guò)貌似下面這個(gè)是對(duì)的，因?yàn)椴槌龅腁BM居然不受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原來(lái)的密碼是123456

FNDCPASS apps/apps 0 Y system/manager01 ALLORACLE apps
--修改所有和ERP相關(guān)的數(shù)據(jù)庫(kù)用戶的密碼為apps

FNDCPASS apps/apps 0 Y system/manager01 oracle hwms 666666
--單獨(dú)修改和ERP相關(guān)的數(shù)據(jù)庫(kù)用戶hwms的密碼為666666
--如果該數(shù)據(jù)庫(kù)用戶和ERP不相關(guān)，會(huì)報(bào)錯(cuò)如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.
--以上命令看起來(lái)是修改applsys，其實(shí)apps和applsys一起都修改了

關(guān)于“ORACLE ERP如何修改密碼”這篇文章就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，使各位可以學(xué)到更多知識(shí)，如果覺(jué)得文章不錯(cuò)，請(qǐng)把它分享出去讓更多的人看到。