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;
Everything Changes
2 weeks ago
No comments:
Post a Comment