Hi All,
Need some clarification on password verification function.
--> Please let me know which password verification function assigned to a user other than default db users.
---> I have a profile other than default profile is app_profile and this profile assigned to database users.
DDL of app_profile i found that PASSWORD_VERIFY_FUNCTION DEFAULT
(And i have created a function "pass_complex_fun" for password verification function.)
Please let me know about DEFAULT for password verify function.
DDL of profile:-
DBMS_METADATA.GET_DDL('PROFILE','APP_PROFILE')
--------------------------------------------------------------------------------
CREATE PROFILE "APP_PROFILE"
LIMIT
COMPOSITE_LIMIT DEFAULT
SESSIONS_PER_USER DEFAULT
CPU_PER_SESSION DEFAULT
CPU_PER_CALL DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
IDLE_TIME DEFAULT
CONNECT_TIME DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME 38880000/86400
PASSWORD_REUSE_MAX 15
PASSWORD_VERIFY_FUNCTION DEFAULT
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
SYS> SELECT * FROM user_password_limits; <-----------From SYS / as SYSDBA
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME 360
PASSWORD_REUSE_MAX 4
PASSWORD_VERIFY_FUNCTION PASS_COMPLEX_FUNC
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME 0
So for other users if i am assigning profile APP_PROFILE then what wold be the PASSWORD_VERIFY_FUNCTION.
DB version 11g
Regards,