1.创建密码复杂度验证
SQL> @?/rdbms/admin/utlpwdmg.sql
Function created.
Grant succeeded.
Profile altered.
Function created.
Grant succeeded.
2.创建概要文件
SQL> create profile my_profile limit
2 failed_login_attempts 3 password_lock_time 2/1440
3 password_verify_function verify_function;
Profile created.
SQL> alter user siebel profile my_profile;
User altered.
④SQL> select username,DEFAULT_TABLESPACE,created,profile from dba_users;
USERNAME DEFAULT_TABLESP CREATED PROFILE
--------------- --------------- --------- ---------------
SIEBEL TS_USERS 11-NOV-16 MY_PROFILE
MGMT_VIEW SYSTEM 11-NOV-16 DEFAULT
SYS SYSTEM 24-AUG-13 DEFAULT
SYSTEM SYSTEM 24-AUG-13 DEFAULT
DBSNMP SYSAUX 24-AUG-13 MONITORING_PROF
ILE
SYSMAN SYSAUX 11-NOV-16 DEFAULT
YYXT YYXT_TBS 11-NOV-16 DEFAULT
OUTLN SYSTEM 24-AUG-13 DEFAULT
FLOWS_FILES SYSAUX 24-AUG-13 DEFAULT
USERNAME DEFAULT_TABLESP CREATED PROFILE
--------------- --------------- --------- ---------------
MDSYS SYSAUX 24-AUG-13 DEFAULT
ORDSYS SYSAUX 24-AUG-13 DEFAULT
EXFSYS SYSAUX 24-AUG-13 DEFAULT
WMSYS SYSAUX 24-AUG-13 DEFAULT
APPQOSSYS SYSAUX 24-AUG-13 DEFAULT
APEX_030200 SYSAUX 24-AUG-13 DEFAULT
OWBSYS_AUDIT SYSAUX 24-AUG-13 DEFAULT
ORDDATA SYSAUX 24-AUG-13 DEFAULT
CTXSYS SYSAUX 24-AUG-13 DEFAULT
ANONYMOUS SYSAUX 24-AUG-13 DEFAULT
XDB SYSAUX 24-AUG-13 DEFAULT
USERNAME DEFAULT_TABLESP CREATED PROFILE
--------------- --------------- --------- ---------------
ORDPLUGINS SYSAUX 24-AUG-13 DEFAULT
OWBSYS SYSAUX 24-AUG-13 DEFAULT
SI_INFORMTN_SCH SYSAUX 24-AUG-13 DEFAULT
EMA
OLAPSYS SYSAUX 24-AUG-13 DEFAULT
SCOTT USERS 24-AUG-13 DEFAULT
ORACLE_OCM USERS 24-AUG-13 DEFAULT
XS$NULL USERS 24-AUG-13 DEFAULT
BI USERS 11-NOV-16 DEFAULT
PM USERS 11-NOV-16 DEFAULT
USERNAME DEFAULT_TABLESP CREATED PROFILE
--------------- --------------- --------- ---------------
MDDATA USERS 24-AUG-13 DEFAULT
IX USERS 11-NOV-16 DEFAULT
SH USERS 11-NOV-16 DEFAULT
DIP USERS 24-AUG-13 DEFAULT
OE USERS 11-NOV-16 DEFAULT
APEX_PUBLIC_USE USERS 24-AUG-13 DEFAULT
R
HR USERS 11-NOV-16 DEFAULT
SPATIAL_CSW_ADM USERS 24-AUG-13 DEFAULT
IN_USR
USERNAME DEFAULT_TABLESP CREATED PROFILE
--------------- --------------- --------- ---------------
SPATIAL_WFS_ADM USERS 24-AUG-13 DEFAULT
IN_USR
38 rows selected.
