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

The password expiration rule of Oracle is managed by Profile. By default, there is only one Profile (DEFAULT) in the system, and the password expiration rule of this profile is 180 days. All users use the profile of this DEFAULT, so if you modify the expiration rule of DEFAULT, it will affect all users. If you want to change a user's password so that it never expires, you need to create a new profile and modify the profile's expiration rule indefinitely, so that the user's expiration rule will change and will not affect other users.

First of all, check which user's proifle is, usually default:

Sql > SELECT username,PROFILE FROM dba_users

USERNAME PROFILE

SCOTT DEFAULT

EXFSYS DEFAULT

ORDSYS DEFAULT

MDSYS DEFAULT

FLOWS_FILES DEFAULT

OMUADM DEFAULT

SYSTEM DEFAULT

SYS DEFAULT

VPXADMIN DEFAULT

2. Check 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'

PROFILE RESOURCE_NAME RESOURCE

-

LIMIT

-

DEFAULT PASSWORD_LIFE_TIME PASSWORD

one hundred and eighty

3. If the password validity period is changed from the default 180 days to "unlimited" here, all users will be affected:

Sql > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

After the modification, there is no need to restart the database, it will take effect immediately.

Note: after modification, accounts that have not been prompted for ORA-28002 warning will not encounter the same prompt again

Accounts that have been prompted must change their passwords again, for example

$sqlplus / as sysdba

Sql > alter user vpxadmin identified by-there is no need to change a new password

So if you want to set a password for a user that will never expire, you can do so. For example, changing the password expiration rule of vpxadmin users to indefinite UNLIMITED requires only three steps:

1. Create a new profile "VPXADMIN_UNLIMIT" with the same rules as DEFAULT (because there are so many items in a profile, we only want to modify the expiration rules at this time, and the rest remain the same)

two。 Modify profile "VPXADMIN_UNLIMIT" and change the expiration rule to UNLIMITED

3. Apply 'VPXADMIN' users to the new profile "PASSWD_UNLIMIT"

1. Create a new profile (VPXADMIN_UNLIMIT) to copy DEFAULT's ScriptCREATE PROFILE "VPXADMIN_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;PROFILE

-

DEFAULT

VPXADMIN_UNLIMIT

Created successfully.

-- 2. Modify the newly created profile (VPXADMIN_UNLIMIT) so that the password expires to a non-expired ALTER profile VPXADMIN_UNLIMIT limit PASSWORD_LIFE_TIME UNLIMITED;--3. Modify the user's Profile to a new profile

Alter user VPXADMIN profile VPXADMIN_UNLIMIT; verify it again, and sure enough!

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.