Small knowledge, big challenge! This article is participating in the creation activity of “Essential Tips for Programmers”.

To view the profile currently in use:

set pages0
set line222
col profile for a20
col resource_name for a30
col resource_type for a20
col limit for a20
select * from dba_profiles order by 1;
Copy the code

Enable password management:

@?/rdbms/admin/utlpwdmg.sql
Copy the code

Adjusting password policies:

alter profile default limit  password_life_time unlimited;
alter profile default limit  password_lock_time unlimited;
alter profile default limit  password_grace_time unlimited;
alter profile default limit  FAILED_LOGIN_ATTEMPTS 10;
Copy the code

This is the end of sharing ~

If you think the article is helpful to you, please like it, favorites it, pay attention to it, comment on it, and support it four times with one button. Your support is the biggest motivation for my creation.

❤️ technical exchange can follow the public number: Lucifer think twice before you do ❤️