CREATE PROFILE ​

Function Description ​

Creates a user profile, which is used to manage resource limits and password policies for database users. A profile can be shared by multiple users, facilitating unified management of user security and resource usage policies.

Precautions ​

Creating or replacing a profile requires the corresponding system permissions. Improper parameter settings may cause account lockout or overly strict password policies. Configure the parameters appropriately based on actual service requirements.

Syntax ​

CREATE PROFILE profile_name [REPLACE] LIMIT
{
    parameter1 [ { UNLIMITED | DEFAULT | value } ]
    [ parameter2 [ { UNLIMITED | DEFAULT | value } ] ]
    ...
}

Parameter Description ​

Basic Parameters ​

Parameter Value Options ​

Configurable Parameter List ​

Examples ​

Creating a Basic Profile ​

CREATE PROFILE app_user_profile LIMIT
    FAILED_LOGIN_ATTEMPTS 5;

Replace an Existing Profile ​

CREATE OR REPLACE PROFILE app_user_profile LIMIT
    FAILED_LOGIN_ATTEMPTS 20;

Creating a Profile Using Default Values ​

CREATE PROFILE default_profile LIMIT
    FAILED_LOGIN_ATTEMPTS DEFAULT;

Creating an Unlimited Profile ​

CREATE PROFILE unlimited_profile LIMIT
    PASSWORD_LIFE_TIME UNLIMITED;