Shulou(Shulou.com)06/02 Report--

In Oracle, you can easily customize the password authentication function, which is used to verify whether the user's new password meets the security standards.

Here is an example of the simplest custom validation function:

SQL > CONN / AS SYSDBA

Connected.

SQL > CREATE OR REPLACE FUNCTION F_MY_VERIFY

2 (P_USERNAME IN VARCHAR2, P_PASSWORD IN VARCHAR2, P_OLD_PASSWORD IN VARCHAR2)

3 RETURN BOOLEAN AS

4 BEGIN

5 IF P_PASSWORD = P_OLD_PASSWORD THEN

6 RAISE_APPLICATION_ERROR (- 20001, 'NEW PASSWORD SAME AS OLD PASSWORD.')

7 END IF

eight

9 IF P_PASSWORD = P_USERNAME THEN

10 RAISE_APPLICATION_ERROR (- 20002, 'PASSWORD SAME AS USERNAME.')

11 END IF

twelve

13 IF INSTR (P_PASSWORD, P_OLD_PASSWORD, 1) > 0 OR INSTR (P_OLD_PASSWORD, P_PASSWORD, 1) > 0 THEN

14 RAISE_APPLICATION_ERROR (- 20003, 'NEW PASSWORD AND OLD PASSWORD ARE LIKE EACH OTHER.')

15 END IF

sixteen

17 IF INSTR (P_PASSWORD, P_USERNAME, 1) > 0 OR INSTR (P_USERNAME, P_PASSWORD, 1) > 0 THEN

18 RAISE_APPLICATION_ERROR (- 20004, 'PASSWORD AND USERNAME ARE LIKE EACH OTHER.')

19 END IF

twenty

21 IF LENGTH (P_PASSWORD)

ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION F_MY_VERIFY

The configuration file has changed

Finally, verify that the verification function is working properly:

SQL > CONN U1/P_U1

Connected.

SQL > ALTER USER U1 IDENTIFIED BY P_U1 REPLACE P_U1

ALTER USER U1 IDENTIFIED BY P_U1 REPLACE P_U1

*

An error occurred on line 1:

ORA-28007: unable to reuse password

SQL > ALTER USER U1 IDENTIFIED BY U1 REPLACE P_U1

ALTER USER U1 IDENTIFIED BY U1 REPLACE P_U1

*

An error occurred on line 1:

ORA-28003: password verification failed for the specified password

ORA-20002: PASSWORD SAME AS USERNAME.

SQL > ALTER USER U1 IDENTIFIED BY P_U123 REPLACE P_U1

ALTER USER U1 IDENTIFIED BY P_U123 REPLACE P_U1

*

An error occurred on line 1:

ORA-28003: password verification failed for the specified password

ORA-20003: NEW PASSWORD AND OLD PASSWORD ARE LIKE EACH OTHER.

SQL > ALTER USER U1 IDENTIFIED BY PASS_U1 REPLACE P_U1

ALTER USER U1 IDENTIFIED BY PASS_U1 REPLACE P_U1

*

An error occurred on line 1:

ORA-28003: password verification failed for the specified password

ORA-20004: PASSWORD AND USERNAME ARE LIKE EACH OTHER.

SQL > ALTER USER U1 IDENTIFIED BY 12345 REPLACE P_U1

ALTER USER U1 IDENTIFIED BY 12345 REPLACE P_U1

*

An error occurred on line 1:

ORA-00988: password missing or invalid

SQL > ALTER USER U1 IDENTIFIED BY "12345" REPLACE P_U1

ALTER USER U1 IDENTIFIED BY "12345" REPLACE P_U1

*

An error occurred on line 1:

ORA-28003: password verification failed for the specified password

ORA-20005: PASSWORD TOO SHORT.

SQL > ALTER USER U1 IDENTIFIED BY NEW_COMPLICATE_PASSWORD REPLACE P_U1

The user has changed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.