首先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

logon The Oracle username/password.
system/password The username and password for the SYSTEM DBA account.
username The APPLSYS username. For example, 'applsys'.
new_password The new password.
--以上命令看起來是修改applsys，其實apps和applsys一起都修改了

To change all ORACLE (type 3) schema passwords:
Use this command to change the passwords of all schemas provided by Oracle Application products.
FNDCPASS 0 Y ALLORACLE
For example, the following command changes all ORACLE schema passwords to "WELCOME":
FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

logon The Oracle username/password.
system/password The username and password for the SYSTEM DBA account.
new_password The new password.

To change an Oracle E-Business Suite schema password (type 3) (other than APPS/APPLSYS):
Use this command to change the password of a schema provided by an individual product in Oracle E-Business Suite.
FNDCPASS 0 Y ORACLE
For example, the following command changes the GL user password to 'GL1'.
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1

logon The Oracle username/password.
system/password The username and password for the SYSTEM DBA account.
username The Oracle username. For example, 'GL'.
new_password The new password.

ORACLE ERP修改密碼的方法

相關文章