--Creating profile profiles
Create Profile profile123 Limit
Failed_login_attempts 2;
--Modify the profile of the user
Alter user Scott profile profile123;
Ensure that the initialization parameter resource_limit is set to true to enforce resource limits in the profile. Otherwise, Oracle ignores the throttling settings in the Create or ALTER PROFILE statement. The profile properties associated with the password do not depend on the Resource_limit parameter, and they start automatically after the profile is created.
--Query the profile of the user
[Email protected] test11g> Select profile from Dba_users
2 where username= ' IKKI ';
Profile
------------------------------
DEFAULT
--View Profile contents
[Email protected] test11g> SELECT DISTINCT Resource_name,limit
2 from Dba_profiles
3 where profile= ' DEFAULT ';
Resource_name LIMIT
-------------------------------- ----------------------------------------
Password_lock_time 1
Idle_time UNLIMITED
Connect_time UNLIMITED
Password_grace_time 7
Logical_reads_per_session UNLIMITED
PRIVATE_SGA UNLIMITED
Logical_reads_per_call UNLIMITED
Sessions_per_user UNLIMITED
Cpu_per_session UNLIMITED
Failed_login_attempts 10
Password_life_time 180
Password_verify_function NULL
Password_reuse_time UNLIMITED
Password_reuse_max UNLIMITED
Composite_limit UNLIMITED
Cpu_per_call UNLIMITED
Rows selected.
--Delete User profile
Drop profile profile123 cascade;
Oracle Basic 09 Profile Profile