how to change Diagnostics -> examine password
-
- Posts: 5
- Joined: Thu Jun 18, 2009 11:52 pm
- Location: Pakistan
how to change Diagnostics -> examine password
please help me on this topic
-
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
Hi,
The below note explanation:(813653.1)
Oracle applications database contains many default, open schemas with default passwords.
These accounts and corresponding passwords are well-known, and they should be changed, especially
for a database to be used in a production environment as a best practice. Default schemas come from different sources and can be classified as below :
1. Default database administration schemas
2. Schemas belonging to optional database features neither used nor patched by E-Business Suite
3. Schemas belonging to optional database features used but not patched by E-Business Suite
4. Schemas belonging to optional database features used and patched by E-Business Suite
5. Schemas common to all E-Business Suite products
6. Schemas associated with specific E-Business Suite products
For the schemas in categories 1, 2 and 3, use standard database commands to change a password:
SQL> alter user <SCHEMA> identified by <NEW_PASSWORD>;
For the schemas in categories 4, 5 and 6, use the application password change tool:
$ FNDCPASS APPS/<apps_pwd> 0 Y SYSTEM/<system_pwd> ORACLE <SCHEMA> <NEW_PWD>
To save time, category six (6) schema passwords may be changed en masse using FNDCPASS. FNDCPASS accepts a keyword ALLORACLE forcing a change of all managed schemas to the new password. If your version of FNDCPASS does not already support the ALLORACLE keyword, apply Patch 5080487.
$ FNDCPASS APPS/<apps_pwd> 0 Y SYSTEM/<system_pwd> ALLORACLE <NEW_PWD>
To determine which schemas are managed by E-Business Suite (categories 4, 5 and 6), run the AD adutconf.sql script.
For detailed information on the list of the schemas by category, instructions and notes for managing schema passwords refer to the ?Appendix C: Database Schemas Shipped with E-Business Suite? section of "Best Practices for Securing Oracle E-Business Suite guide
Thanks & Regards,
Siva
The below note explanation:(813653.1)
Oracle applications database contains many default, open schemas with default passwords.
These accounts and corresponding passwords are well-known, and they should be changed, especially
for a database to be used in a production environment as a best practice. Default schemas come from different sources and can be classified as below :
1. Default database administration schemas
2. Schemas belonging to optional database features neither used nor patched by E-Business Suite
3. Schemas belonging to optional database features used but not patched by E-Business Suite
4. Schemas belonging to optional database features used and patched by E-Business Suite
5. Schemas common to all E-Business Suite products
6. Schemas associated with specific E-Business Suite products
For the schemas in categories 1, 2 and 3, use standard database commands to change a password:
SQL> alter user <SCHEMA> identified by <NEW_PASSWORD>;
For the schemas in categories 4, 5 and 6, use the application password change tool:
$ FNDCPASS APPS/<apps_pwd> 0 Y SYSTEM/<system_pwd> ORACLE <SCHEMA> <NEW_PWD>
To save time, category six (6) schema passwords may be changed en masse using FNDCPASS. FNDCPASS accepts a keyword ALLORACLE forcing a change of all managed schemas to the new password. If your version of FNDCPASS does not already support the ALLORACLE keyword, apply Patch 5080487.
$ FNDCPASS APPS/<apps_pwd> 0 Y SYSTEM/<system_pwd> ALLORACLE <NEW_PWD>
To determine which schemas are managed by E-Business Suite (categories 4, 5 and 6), run the AD adutconf.sql script.
For detailed information on the list of the schemas by category, instructions and notes for managing schema passwords refer to the ?Appendix C: Database Schemas Shipped with E-Business Suite? section of "Best Practices for Securing Oracle E-Business Suite guide
Thanks & Regards,
Siva
Who is online
Users browsing this forum: No registered users and 7 guests