SQL> CREATE PROFILE TOM_PASSWD LIMIT 2 PASSWORD_LIFE_TIME 60 -- 60狩 れ襯 覦蠖 . 3 PASSWORD_GRACE_TIME 10 -- 60殊 讌 蟆所覃語螳 10朱 覲伎讌. 4 PASSWORD_REUSE_TIME 1800 -- 螳 れ襯 1800 覈詞郁 . 5 PASSWORD_REUSE_MAX UNLIMITED -- 螳 れ襯 覓伎朱 れ . 6 FAILED_LOGIN_ATTEMPTS 3 -- 3覯伎 襦蠏語 ろ覃 螻 蠍企. 7 PASSWORD_LOCK_TIME 1/1440 -- 3覯伎 蠍 螻 1覿(1/1440)れ 朱 襴磯. 8 ; 襦殊 焔給. SQL> CREATE USER TOM IDENTIFIED BY TOM 2 DEFAULT TABLESPACE USERS 3 TEMPORARY TABLESPACE TEMP 4 QUOTA 0 ON SYSTEM 5 QUOTA 50M ON USERS 6 PROFILE TOM_PASSWD; 螳 焔給. SQL> GRANT CONNECT TO TOM; 蟠 覿給. SQL> CONNECT TOM/TON ERROR: ORA-01017: 覈/瑚 覿, 襦蠏語 給 蟆所: 伎 ORACLE 郁屋 讌 給. SQL> CONNECT TOM/TON ERROR: ORA-01017: 覈/瑚 覿, 襦蠏語 給 SQL> CONNECT TOM/TON ERROR: ORA-01017: 覈/瑚 覿, 襦蠏語 給 SQL> CONNECT TOM/TON ERROR: ORA-28000: 螻 蠍給 SQL>REM 1覿... SQL> CONNECT TOM/TOM; 郁屋給. SQL> SQL> REM VERIFY_FUNCTION 覦 SYSろる 語伎 . SQL> CONNECT INTERNAL 郁屋給. SQL> REM VERIFY_FUNCTION 襷り覲 覦 螳 3螳伎 . SQL> CREATE OR REPLACE FUNCTION FUNC_TOM_PASSWD 2 (USERNAME IN VARCHAR2, 3 PASSWORD IN VARCHAR2, 4 OLD_PASSWORD IN VARCHAR2 5 ) 6 RETURN BOOLEAN IS 7 BEGIN 8 IF(USERNAME = PASSWORD) THEN 9 RAISE_APPLICATION_ERROR(-20001, 'れ螳 覈螻 狩.'); 10 RETURN FALSE; 11 END IF; 12 13 RETURN TRUE; 14 END; 15 / 螳 焔給. SQL> ALTER PROFILE TOM_PASSWD LIMIT 2 PASSWORD_VERIFY_FUNCTION FUNC_TOM_PASSWD; 襦殊 覲蟆暑給. SQL> CREATE USER TEST IDENTIFIED BY TEST 2 PROFILE TOM_PASSWD; CREATE USER TEST IDENTIFIED BY TEST * 1 る: ORA-28003: 讌 語 蟆讀 ろ給 ORA-20001: れ螳 覈螻 狩. SQL> CREATE USER TEST IDENTIFIED BY TEST1 2 PROFILE TOM_PASSWD; 螳 焔給. SQL>