Profile_oracle sets a user password to never expire, and the oracle Password Never Expires

Profile_oracle sets a user password to never expire, and the oracle Password Never Expires

Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46888139

 

Setting a user password in oracle never expires

 

Set the password for the ETL_TEST user to never expire.

Select * from dba_users where username = 'etl _ test ';

View the dba_users dictionary to know that the ETL_TEST user will expire on March 13, November 23, 2015.

Select username, user_id, account_status, expiry_date, profile from dba_users where username = 'etl _ test ';

The profile parameter is default.

SELECT username, profile from dba_users where username = 'etl _ test ';

The profile parameter is default, and the password is valid for a long time, as shown below:

SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

As you can see, set profile to default and set password to 180 days after expiration.

We can create a profile file for a user.

Create a profile file named passwd_unlimit and set the password under its profile to never expire.

Create profile passwd_unlimit limit PASSWORD_LIFE_TIME unlimited;

Set the initialization parameter of passwd_unlimit to the ETL_TEST user. As follows:

Alter user ETL_TEST profile passwd_unlimit;

After the configuration is complete, run dba_users to check whether the profile file of ETL_TEST is successfully set, as shown below:

Select username, user_id, account_status, expiry_date, profilefrom dba_users where username = 'etl _ test ';

You can see that the profile file of ETL_TEST is set to passwd_unlimit, while the profile file of passwd_unlimit is set to the password never expires.

Finally, let's check which resource settings attached to the profile file named PASSWD_UNLIMIT are as follows:

SELECT * FROM dba_profiles s WHERE s. profile = 'passwd _ UNLIMIT ';

We can see that PASSWORD_LIFE_TIME is indeed set to UNLIMITED.

So far, we have achieved the goal that the ETL_TEST user password will never expire.

In addition, other resources are not set in the profile file named PASSWD_UNLIMIT. We need to adjust other resources to meet the requirements.

For example, I subsequently executed the following settings:

ALTER profile passwd_unlimit limit COMPOSITE_LIMIT UNLIMITED;

ALTER profile passwd_unlimit limit SESSIONS_PER_USER UNLIMITED;

ALTER profile passwd_unlimit limit CPU_PER_SESSION UNLIMITED;

ALTER profile passwd_unlimit limit CPU_PER_CALL UNLIMITED;

ALTER profile passwd_unlimit limit LOGICAL_READS_PER_SESSIONUNLIMITED;

ALTER profile passwd_unlimit limit LOGICAL_READS_PER_CALL UNLIMITED;

ALTER profile passwd_unlimit limit IDLE_TIME UNLIMITED;

ALTER profile passwd_unlimit limit CONNECT_TIME UNLIMITED;

ALTER profile passwd_unlimit limit PRIVATE_SGA UNLIMITED;

ALTER profile passwd_unlimit limit FAILED_LOGIN_ATTEMPTS 10;

ALTER profile passwd_unlimit limit PASSWORD_REUSE_TIME UNLIMITED;

ALTER profile passwd_unlimit limit PASSWORD_REUSE_MAX UNLIMITED;

ALTER profile passwd_unlimit limit PASSWORD_VERIFY_FUNCTION NULL;

ALTER profile passwd_unlimit limit PASSWORD_LOCK_TIME 1;

ALTER profile passwd_unlimit limit PASSWORD_GRACE_TIME 7;

Let's take a look at the affiliated resource settings under the profile file named PASSWD_UNLIMIT, as follows:

So far, each resource in the profile file of PASSWD_UNLIMIT is configured to meet the needs of this user.

 

Summary:

1. syntax for creating a profile:

Create profile [PROFILE] limit [RESOURCE_TYPE] [LIMIT];

Example: create profile passwd_unlimit limit PASSWORD_LIFE_TIME unlimited;

 

2. Change the profile Syntax:

Alter user [user] profile [profile];

Example: alter user ETL_TEST profile passwd_unlimit;

 

3. Change the configuration Syntax of a source in a profile:

ALTER profile [profile] limit [source] [option];

Example: ALTER profile passwd_unlimitlimit COMPOSITE_LIMIT UNLIMITED;

 

**************************************** * ** Blue growth series ********************************* *******************

Original works, from the blog of "Deep Blue". You are welcome to reprint them. Please indicate the source (Http://blog.csdn.net/huangyanlong).

Blue growth note-chasing DBA (1): traveling on the road to Shandong

Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs.

Blue growth note-chasing DBA (3): importing and exporting data on antiques becomes a problem

Blue growth note-chasing DBA (4): recalling the sorrow of teenagers, and exploring oracle Installation (10g and 11g in Linux)

Blue growth note-chasing DBA (5): Not talking about technology or business, annoying Application Systems

Blue growth note-chasing DBA (6): doing things and being human: Small technology, great human

Blue growth note-Chase DBA (7): Basic commands, foundation stone

Blue growth notes-chasing DBA (8): repicking SP reports and recalling oracle's STATSPACK Experiment

Blue growth note-chasing DBA (9): Chasing DBA, new planning, new departure

Blue growth note-chasing DBA (10): Flying knife defense, familiarity rather than expertise: Playing with middleware Websphere

Blue growth note-chasing DBA (11): It's easy to go home and wake up.

Blue growth notes-Chase DBA (12): seven days and seven gains of SQL

Blue growth note-chasing DBA (13): Coordinating hardware manufacturers, six stories: what you see as "servers, storage, switches ......"

Blue growth note-chasing DBA (14): An unforgettable "Cloud" end, started hadoop deployment

Blue growth note-chasing DBA (15): Who thinks FTP is "simple" and thinks it is a trigger

Blue growth note-chasing DBA (16): DBA also drank alcohol and was rejected

Blue growth note-Chase DBA (17): whether to share or consume, learn to grow in the Post-IOE Era

**************************************** **************************************** **********************************

 

**************************************** ******************************** *****************

Original works, from the blog of "Deep Blue". You are welcome to reprint them. Please indicate the source (Http://blog.csdn.net/huangyanlong).

Football and oracle series (1): 32-way zhoudianbing, overall view of group A Brazil smon process of oracle32 process Alliance

Football and oracle series (2)

Football and oracle series (3): oracle process rankings, the World Cup round is about to fight!

Football and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison! 

Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package!

Football and oracle series (6): Asian Cup with database creation-come on, Chinese Team

**************************************** **************************************** **********************************

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.