Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle EBS database password complexity setting

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

As required by the audit, you need to set the password complexity of the default profile as follows:

1. Check the configuration files related to password settings in Oracle database.

SELECT * FROM Dba_Profiles d WHERE d.profileholders default

It is found that no password security settings have been made.

2. Therefore, check the complexity of the opening password.

Execute @? / rdbms/admin/utlpwdmg.sql

3. Query the parameters of the DEFAULT configuration file again. The following password complexity is set successfully

4. If you do not need to set password complexity check, the command is as follows:

Alter profile default limit PASSWORD_VERIFY_FUNCTION null

If you need to modify the profile value corresponding to the user, the command is as follows:

Alter user scott profile XXX

For the EBS system, do not change the password setting of DEFAULT at will, otherwise it is easy to go wrong, the password will be locked or invalidated inexplicably, and if you change the applsyspub, the EBS FORM will still be unable to open. The effect is as follows:

The fix method is to leave the password complexity blank and restore the applsyspub password. The applsyspub password can be entered into the application server, and the password can be obtained from the configuration file in the cd $FND_SECURE directory (the parameter GWYUID in the configuration file has the corresponding account and password information), and execute the command:

Alter profile default limit PASSWORD_VERIFY_FUNCTION null

Alter user APPLSYSPUB identified by pub

Alter user APPLSYSPUB account unlock

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report