Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the rules for setting Oracle username and password". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn what are the rules for setting Oracle username and password.

1. Query current user using profile and profile Rule 1.1 query current user using profile

$sqlplus / as sysdba

SQL > select profile,resource_name,resource_type,limit from dba_profiles where profile= (select PROFILE from dba_users where username=upper ('& user_name'))

1.2 load the built-in password complexity function

$sqlplus / as sysdba

SQL > @? / rdbms/admin/utlpwdmg.sql

L minimum length 8

L cannot be the same or similar to the user name

L cannot be a user name in reverse order.

L cannot be the same as the previous password with more than 3 characters

L contains at least one "\", "number" and "character"

two。 Modify the current profile or create a separate profile to modify the current user using profile using password authentication function 2.1

$sqlplus / as sysdba

SQL > select 'alter profile' | | profile | |

'limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION;'

From dba_profiles

Group by profile

'ALTERPROFILE' | | PROFILE | | 'LIMITPASSWORD_VERIFY_FUNCTIONVERIFY_FUNCTION;'

-

Alter profile MONITORING_PROFILE limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION

Alter profile DEFAULT limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION; # can use the corresponding profile statements that need to be modified.

SYS@honor1 > alter profile DEFAULT limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION

Profile altered.

SYS@honor1 > alter user hr identified by 111111; # rules have come into effect and simple passwords can no longer be used

Alter user hr identified by 111111

*

ERROR at line 1:

ORA-28003: password verification for the specified password failed

ORA-20003: Password should contain at least one\

Digit, one character and one punctuation

2.2 create profile setting rules

SYS@honor1 > CREATE PROFILE new_profile LIMIT

SESSIONS_PER_USER UNLIMITED

CPU_PER_SESSION UNLIMITED

CPU_PER_CALL UNLIMITED

CONNECT_TIME UNLIMITED

IDLE_TIME 600

LOGICAL_READS_PER_SESSION UNLIMITED

LOGICAL_READS_PER_CALL UNLIMITED

COMPOSITE_LIMIT UNLIMITED

PRIVATE_SGA UNLIMITED

FAILED_LOGIN_ATTEMPTS UNLIMITED

PASSWORD_LIFE_TIME UNLIMITED

PASSWORD_REUSE_TIME UNLIMITED

PASSWORD_REUSE_MAX UNLIMITED

PASSWORD_LOCK_TIME 1

PASSWORD_GRACE_TIME 10

PASSWORD_VERIFY_FUNCTION verify_function

Profile created.

SYS@honor1 > alter user hr profile new_profile

User altered.

SYS@honor1 > alter user hr identified by 111111

Alter user hr identified by 111111

*

ERROR at line 1:

ORA-28003: password verification for the specified password failed # the new rules have come into force

ORA-20003: Password should contain at least one\

Digit, one character and one punctuation

3. Fallback 3.1 modify profile attribute fallback

SYS@honor1 > alter profile DEFAULT limit PASSWORD_VERIFY_FUNCTION null

Profile altered.

SYS@honor1 > alter user hr identified by 111111; # you can see that the password rules have expired

User altered.

3.2 New profile fallback

SYS@honor1 > alter user hr profile default; # enter the original name if you originally used a custom profile

User altered.

SYS@honor1 > alter user hr identified by 111111; # you can see that the password rules have expired

User altered.

4. Password validity period

SYS@honor1 > alter profile DEFAULT limit PASSWORD_LIFE_TIME 90; # modified to 90 days

Profile altered.

SYS@honor1 > select profile,resource_name,resource_type,limit from dba_profiles where profile='DEFAULT'

Caution:

Set a short period of validity, be sure to pay attention to the password validity period, and change the password before the validity period in time to prevent the application from failing to connect to the database due to password expiration.

5. Interval between re-use of the same password

SYS@honor1 > alter profile default limit PASSWORD_REUSE_TIME 365

Profile altered.

SYS@honor1 > select profile,resource_name,resource_type,limit from dba_profiles where profile='DEFAULT'

6. Number of times the same password can be used

SYS@honor1 > alter profile default limit PASSWORD_REUSE_MAX 5

Profile altered.

SYS@honor1 > select profile,resource_name,resource_type,limit from dba_profiles where profile='DEFAULT'

7. Roll back the above settings

SYS@honor1 > alter profile DEFAULT limit PASSWORD_LIFE_TIME 180

SYS@honor1 > alter profile default limit PASSWORD_REUSE_TIME UNLIMITED

SYS@honor1 > alter profile default limit PASSWORD_REUSE_MAX UNLIMITED

Thank you for your reading, the above is the content of "what are the rules for setting Oracle username and password". After the study of this article, I believe you have a deeper understanding of what the rules for setting Oracle username and password are, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.