how to show user profile and change its limit ?
==============================================
1. First see the profile which are using my user ;
SELECT *
FROM dba_users
WHERE USERNAME='ISLBAS';
2. For showing the specific profiles property
select * from dba_profiles
where profile='DEFAULT'
--profile attribute
select * from profile$
---profile names
select * from profname$
SELECT name, lcount
FROM user$
WHERE lcount <> 0;
3.In order to track password related profile limits, Oracle stores the history
of passwords for a user in user_history$.
select * from user_history$
4. To change profile limit use
ALTER PROFILE default limit
failed_login_attempts UNLIMITED;
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment