Oracle Basic 09 Profile Profile

Source: Internet
Author: User

--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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.