/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

1 vote177 views1 answer
Delete mysql from mac
SQL
0 vote188 views1 answer
How to check even or odd in sql
SQL
0 vote148 views2 answers
Spring properties file for db
SQL
0 vote190 views1 answer
Oracle calculate statistics on partition
SQL
94 votes402 views4 answers
Create database postgres
SQL
0 vote147 views1 answer
Mysql collation for all languages
SQL
0 vote222 views1 answer
Psql create usr
SQL
0 vote191 views1 answer
Groupby sort sql hive
SQL
0 vote198 views1 answer
Rabbitmq ui not working
SQL
35 votes200 views6 answers
Postgres
SQL