问题描述
数据库版本:
select version from v$instance; VERSION ----------------- 11.2.0.4.0
自建了一个profile规则内容如下:
select PROFILE,RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where PROFILE='AUD'; PROFILE RESOURCE_NAMERESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- AUD COMPOSITE_LIMITKERNEL DEFAULT AUD SESSIONS_PER_USERKERNEL DEFAULT AUD CPU_PER_SESSIONKERNEL DEFAULT AUD CPU_PER_CALLKERNEL DEFAULT AUD LOGICAL_READS_PER_SESSIONKERNEL DEFAULT AUD LOGICAL_READS_PER_CALLKERNEL DEFAULT AUD IDLE_TIMEKERNEL DEFAULT AUD CONNECT_TIMEKERNEL DEFAULT AUD PRIVATE_SGAKERNEL DEFAULT AUD FAILED_LOGIN_ATTEMPTSPASSWORD 10 AUD PASSWORD_LIFE_TIMEPASSWORD 100 PROFILE RESOURCE_NAMERESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- AUD PASSWORD_REUSE_TIMEPASSWORD DEFAULT AUD PASSWORD_REUSE_MAXPASSWORD DEFAULT AUD PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G AUD PASSWORD_LOCK_TIMEPASSWORD 3 AUD PASSWORD_GRACE_TIMEPASSWORD 15
orapwd [IGNORECASE={Y|N}] -----未重建 默认为Y。
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE 未执行。
@$ORACLE_HOME/rdbms/admin/utlpwdmg.sql --sys已执行
GRANT EXECUTE ON verify_function_11G to te1;
select USERNAME,ACCOUNT_STATUS,PROFILE,AUTHENTICATION_TYPE from dba_users where username in ('TE1','SYS'); USERNAME ACCOUNT_STATUSPROFILE AUTHENTI ------------------------------ -------------------------------- ------------------------------ -------- SYS OPENAUD PASSWORD TE1 OPENAUD PASSWORD
问题1:怎么才能让原有用户登录时出现密码规则提示进行密码重置?(以下步骤未出现该提示)
SQL> conn te1/te1 Connected. SQL>
问题2:sys用户不受密码规则约束,如何让其受约束?
user:te1 SQL> alter user te1 identified by 123; alter user te1 identified by 123 * ERROR at line 1: ORA-28003: password verification for the specified password failed ORA-20001: Password length less than 8 user:sys SQL> alter user sys identified by 123; User altered. [oracle@rt2 dbs]$ orapwd file=orapwrs entries=10 password=123456 [oracle@rt2 dbs]$ sqlplus sys/123456 as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 13 12:02:39 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select user from dual; USER ------------------------------ SYS
专家解答
1、alter user test password expire;
2、SYS用户通过密码文件验证,无法使用此规则的。
最后修改时间:2019-03-20 21:33:12
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。