/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

21 votes367 views1 answer
Cheatsheet for sql
SQL
0 vote354 views1 answer
Mysql filter based on datediff
SQL
42 votes445 views6 answers
Install beautifulsoup
SQL
0 vote357 views1 answer
Export partttion and import in oracle
SQL
0 vote337 views1 answer
Resulting Query
SQL
0 vote350 views1 answer
How to use query in nosql
SQL
1 vote350 views1 answer
Increase existing date in sql oracle
SQL
1 vote381 views1 answer
Oracle nvl2
SQL
0 vote312 views1 answer
Flask_sqlalchemy install
SQL
2 votes356 views1 answer
Pandas to sql index
SQL