How does oracle change the password of a user to be permanent?
The main content of this article is to explain "how to change the password of a user to be permanent". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to change the password of a user to be permanent" by oracle.
Set a password that will never expire. First, check which user's proifle is, usually default:
Sql > SELECT username,PROFILE FROM dba_users
View the password validity settings for the specified profile, such as default:
Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'
Set the password for a user to never expire
For example, modify the password expiration rule of FSJT_USER users to UNLIMITED indefinitely.
1. New profile "FSJT_USER_UNLIMIT", the rules are the same as DEFAULT (because a profile contains a lot of items, we only want to modify the expiration rules at this time, other rules remain the same)
CREATE PROFILE "FSJT_USER_UNLIMIT" LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
PASSWORD_VERIFY_FUNCTION NULL
Then check it out.
SELECT profile FROM dba_profiles
-
DEFAULT
FSJT_USER_UNLIMIT
two。 Modify the newly created profile (FSJT_USER_UNLIMIT). Password expires if it does not expire.
ALTER profile FSJT_USER_UNLIMIT limit PASSWORD_LIFE_TIME UNLIMITED
3. Modify the user's Profile to a new profile
Alter user FSJT_USER profile FSJT_USER_UNLIMIT
At this point, I believe you have a deeper understanding of "how to change the password of a user to be permanent". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
