Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

Wednesday, January 13, 2010

Account Lock Time

SELECT profile, limit
FROM dba_profiles,
(SELECT limit AS def_pwd_lock_tm
FROM dba_profiles
WHERE profile = 'DEFAULT'
AND resource_name = ' PASSWORD_LOCK_TIME ')
WHERE resource_name = ' PASSWORD_LOCK_TIME '
AND ((replace(limit,'DEFAULT',def_pwd_lock_tm) IN ('UNLIMITED',NULL))
OR (lpad(replace(limit,'DEFAULT',def_pwd_lock_tm),40,'0') <
lpad('.0104',40,'0')));

No comments: