In dba_users table expiry_date and lock_date empty after creating profiles
268252Mar 18 2004 — edited Mar 26 2004Hi,
How to see that how many more days does the user's password is still valid.
I have created a user. Subsequently created a
profile.
create profile man LIMIT
failed_login_attempts 2
idle_time 30
password_lock_time 30
password_grace_time 2;
-- assigned rag user the profile.
alter user rag profile man.
when I query the details in dba_profiles.
SQL> select * from dba_profiles;
PROFILE---RESOURCE_NAME RESOURCE LIMIT
---------- --------------------------- -------- ----------
MAN------COMPOSITE_LIMIT KERNEL DEFAULT
MAN------SESSIONS_PER_USER KERNEL DEFAULT
MAN------CPU_PER_SESSION KERNEL DEFAULT
MAN------CPU_PER_CALL KERNEL DEFAULT
MAN------LOGICAL_READS_PER_SESSION KERNEL DEFAULT
MAN------LOGICAL_READS_PER_CALL KERNEL DEFAULT
MAN------IDLE_TIME KERNEL 30
MAN------CONNECT_TIME KERNEL DEFAULT
MAN------PRIVATE_SGA KERNEL DEFAULT
MAN------FAILED_LOGIN_ATTEMPTS PASSWORD 2
MAN------PASSWORD_LIFE_TIME PASSWORD DEFAULT
MAN------PASSWORD_REUSE_TIME PASSWORD DEFAULT
MAN------PASSWORD_REUSE_MAX PASSWORD DEFAULT
MAN------PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
MAN------PASSWORD_LOCK_TIME PASSWORD 30
MAN------PASSWORD_GRACE_TIME PASSWORD 2
when I query dba_users :
select username,expiry_Date,lock_Date,profile from dba_users and username like '%rag%';
the result is :
USERNAME---EXPIRY_DATE---LOCK_DATE---PROFILE
------------------------------------------------------------
rag -----------[no val empty?? ]------[no val empty ??]--------man
I am unable to see values in expiry_Date and lock_Date column.!!
If I need to see how many mored days does the user's accout is valid then where else should I query ?
or
Is their any other way to query and see that, how many more days does the user is valid??