oracle 约束大于0,oracle db:11.2.0.4 sys用户不受自建profile规则约束

数据库版本:

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值