/SQL/Oracle change password expiration policy

Oracle change password expiration policy

CREATE PROFILE SHORT_LIFE_PROFILE LIMIT
    PASSWORD_LIFE_TIME 1/24/60/60 		--> 1 second
    PASSWORD_GRACE_TIME 1/24; 			--> 1 hour

ALTER USER user_name PROFILE SHORT_LIFE_PROFILE;    -- Log on to refresh

SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME = 'user_name';

Source: stackoverflow.com

Similar codes

7 votes212 views2 answers
How to create index mysql
SQL
0 vote218 views1 answer
Microsoft word insert sql code
SQL
0 vote204 views1 answer
Gcloud sql list databases
SQL
0 vote188 views1 answer
How to reset AI in sql
SQL
6 votes224 views2 answers
Mysql 1 day ago
SQL
-1 vote215 views4 answers
Restart mysql server ubuntu
SQL
0 vote189 views1 answer
Jenkins SQLCMD run
SQL
0 vote281 views1 answer
Linux upload database to mysql
SQL
3 votes185 views1 answer
How to remove characters from string in mysql
SQL
3 votes176 views3 answers
Print in pl sql
SQL