oracle中修改用户密码复杂度的具体例子及操作过程（unix中）
5星 · 超过95%的资源 需积分: 50 28 浏览量
2008-07-21
20:30:55
上传
评论 1
收藏 38KB DOC 举报 
一.修改密码复杂读
更改 orcle 数据库用户的密码复杂度
1. 用 sys 用户创建存储过程
#splplus /nolog
SQL>connect /as sysdba
SQL>CREATE OR REPLACE FUNCTION verify_passwd
(username varchar2,
password varchar2,
old_password varchar2)
RETURN boolean IS
n boolean;
m integer;
differ integer;
isdigit boolean;
ischar boolean;
ispunct boolean;
digitarray varchar2(20);
punctarray varchar2(25);
chararray varchar2(52);
BEGIN
digitarray:= '0123456789';
chararray:= 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
punctarray:='!"#$%&()``*+,-/:;<=>?_';
-- Check if the password is same as the username
IF NLS_LOWER(password) = NLS_LOWER(username) THEN
raise_application_error(-20001, 'Password same as or similar to user');
END IF;
-- Check for the minimum length of the password
IF length(password) < 4 THEN
raise_application_error(-20002, 'Password length less than 4');
END IF;
-- Check if the password is too simple. A dictionary of words may be
-- maintained and a check may be made so as not to allow the words
-- that are too simple for the password.
IF NLS_LOWER(password) IN ('welcome', 'database', 'account', 'user', 'password', 'oracle',
'computer', 'abcd') THEN
raise_application_error(-20002, 'Password too simple');
END IF;
资源评论
yulin_zq2013-04-24很实用的案例
Young_272018-09-18好多行代码，学习中！先赞一个！
hmz3498537142013-10-20大致的看了一下方案，应该很实用的！- fuyishu2013-12-19应该很实用的！学习中～～～～
