We divide the EBS system password into four categories, and change the password must comply with the regulations and specifications, especially backup.
1. Operating System users, such as root, ora, and Appl. [Modification method] use the OS command passwd to change the user password. For example, passwd rootpasswd orapasswd apps [production Password] 12345678 [test and DG Environment] 12345678 [note] none. If you forget the root password, you can log on to the OS in single-user mode to change the root password. Theoretically, changing the operating system user password does not affect the EBS system.
2. Database User 2.1, for example, sys and system, users in any Oracle database can log on with sqlplus or other clients. Users cannot log on from the ERP homepage and use the database command alter user to change the database. Schemas that exist in every Oracle Database (whether used by Oracle Applications or not) [EX: SYS, system]. [modification method] alter user SYS identified by 12345678; Alter user system identified by 12345678; Note: backup before change, [sys user] Create Table sys. user $ _ 20140506 as select * From sys. user $;
2.2 dB users associated with ERP systems are DB users and ERP users. It is reflected in user $ and apps. fnd_oracle_userid. Backup before modification: Create Table apps. fnd_user_20140506 as select * from apps. fnd_user; Create Table apps. fnd_oracle_userid_20140506 as select * from apps. fnd_oracle_userid;
A. apps and applsys, applsyspub user a small set of schemas used by shared components of Oracle Applications [for example, applsyspub, applsys, apps]. [dba_users] [fnd_oracle_userid] The fndcpass tool automatically sets the passwords of apps and applsys users to the same. [[Email protected] ~] $ Fndcpass apps/apps 0 y systems/123456 system applsys 12345678
Note: A. Stop the entire application layer, especially the concurrency manager, before changing the password. B. after modification, check the log to see if any error is reported. Do not manually run the auoconfig command, C. after modification, the ERP system becomes abnormal. Use the following method to roll back insert into apps. fnd_user select * from apps. fnd_user_yyyymmdd; insert into apps. fnd_oracle_userid select * from apps. fnd_oracle_userid_yyyymmdd; commit;
B. basic module user a large set of schemas provided by the individual products of Oracle Applications [for example, ABM, Ahl ,..., zsa, ZX]. fndcpass apps/12345678 0 y system/12345678 Oracle GL 12345678 one-time modification of all module users, as follows: fndcpass apps/12345678 0 y system/12345678 alloracle 12345678
C. This type is the non-basic Module User a set of schemas that belong to optional database features or third party products These fall into three subtypes managed by EBS. The password must be modified separately. SQL> select oracle_username from applsys. fnd_oracle_userid where read_only_flag = 'X' and oracle_username in (select username from SYS. dba_users );
Oracle_username ------------------------------ ODM -- ctxsys, a user who uses data mining, and intermedia text
Fndcpass apps/12345678 y system/12345678 oracle "ODM" 12345678 fndcpass apps/12345678 0 y system/12345678 oracle "ctxsys" 12345678
3. users such as ERP application system users log on to the web page, and sqlplus users cannot log on to the database. Such users are not DB users and are not reflected in the DB dba_users table. Among them, SysAdmin is the most typical, is also a very large EBS administrator user, other users such as O-TIN.
Used when users log on to the ERP system from the web. A. These users can log on and modify the settings on their own through the webpage. B. They can also help the SysAdmin administrator to modify the settings. C. They can also allow the Administrator to modify the Settings Using the OS fndcpass tool. D. You can modify it through the Oracle interface.
From apps. fnd_user. Fndcpass apps/apps 0 y system/123456 user sysadmin12345678
Batch modification: Select 'fndcpass apps/clone 0 y system/clone user' | user_name | 'clone 'from apps. fnd_user where email_address is not null and created_by = 0 or created_by> 500 and person_party_id is not null and user_name <> 'sysadmin'
Modify by using the interface: Begin apps. xxpkg_usr.pwd ('xiaoming. Lil', '123'); end;
EBS system multi-level password and modification method
