Thursday, July 8, 2010

how to show user profile and change its limit ?

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;

No comments: