创建一用户
create user test identified by <passwdXXXXX> default tablespace test temporary tablespace test;
授权
grant dba, connect, resource, create table to test;
PL/SQL function that makes a
password complexity check
before a password is assigned
Function must be created in the SYS schema and
must have the following specification:
function_name(
userid_parameter IN VARCHAR2(30),
password_parameter IN VARCHAR2(30),
old_password_parameter IN VARCHAR2(30))
RETURN BOOLEAN
然后,创建一个profile,使用这个密码验证函数。
创建用户,使用这个profile