Usage of user profile in Oracle

You can use the profile file to define user attributes. For example, you can create a profile file for the product user.
SQL code
Create profile product_profile limit SESSIONS_PER_USER 1;

-- Only one user can be set
SQL code
Session profile alter user product profile product_profile;

-- Let product users use product_profile
To make the preceding restrictions take effect, you need to modify the initialization parameter resource_limit.
SQL code
Show parameter resource;
NAME TYPE VALUE
-----------------------------------------------------------------------------
Resource_limit boolean FALSE
Resource_manager_plan string

We can see that the value of resource_limit is false and the value is changed to true.
SQL code
Alter system set resource_limit = true;

You can view the dba_profiles view to view users' default properties.
You can use the following method to modify the number of failed logons, for example, modifying the user's logon attempts. The default value is 10 and the value is unlimited alter profile PRODUCT_PROFILE limit FAILED_LOGIN_ATTEMPTS unlimited. -- modify the number of failed logons.

Author: "fighter plane"