/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 vote175 views1 answer
Oracle user last connected
SQL
4 votes182 views4 answers
Oracle tablespace tables list
SQL
1 vote180 views1 answer
Loading local data is disabled mysql
SQL
0 vote177 views1 answer
Sql server convert date to weekday
SQL
2 votes181 views2 answers
Postgres select duplicate columns
SQL
20 votes183 views2 answers
Mysql bigint max value
SQL
1 vote171 views1 answer
Local sql server
SQL
1 vote208 views1 answer
Mysql view current queries
SQL
0 vote171 views1 answer
How to check if there is no database schema
SQL
0 vote187 views1 answer
Oracle procedure teamplate
SQL