oracle用户密码密码的生成
Oracle7-Oracle10,用DES加密密码,一直将用户名与密码一起做hash运算,例如sys/temp1与system/p1是相同的密码串。密码都强制转换成全大写。dba_users中的password可以看到密码密文。
SQL> grant dba to fwy6 identified by paic1234;
Grant succeeded
SQL> grant dba to fwy6p identified by aic1234;
Grant succeeded
SQL> select password from dba_users t where t.created>sysdate-1;
PASSWORD ------------------------------ DC3534D0BCEEDBE0 DC3534D0BCEEDBE0
SQL> alter user fwy6p identified by paic1234;
User altered
SQL> select password from dba_users t where t.created>sysdate-1;
PASSWORD ------------------------------ DC3534D0BCEEDBE0 C772C2461B9F9E8D
11g开始:仍然是将用户名与密码一起做hash运算,但允许大小写混合方式 alter user fwy2 identified by PAic1234;通过password|username的方式进行hash dba_users中的password不可以看到密码密文,而必须用sys用户查看user$视图
SQL> grant dba to fwy6 identified by paic1234;
Grant succeeded
SQL> grant dba to fwy6p identified by aic1234;
Grant succeeded SYS@epsstg> select password from user$ t where name in ('FWY6','FWY6P'); PASSWORD -------------------------------------------------------------------------------- DC3534D0BCEEDBE0 DC3534D0BCEEDBE0
- 01-11全球最受赞誉公司揭晓:苹果连续九年第一
- 12-09罗伯特·莫里斯:让黑客真正变黑
- 12-09谁闯入了中国网络?揭秘美国绝密黑客小组TA
- 12-09警示:iOS6 惊现“闪退”BUG
- 05-15奇安信:数据安全问题是医疗卫生行业数字化
- 05-15腾讯宣布混元文生图大模型开源
- 05-15网易云音乐与韩国知名娱乐公司Kakao达成战略
- 05-15阿联酋宣告正式开启“5G-A全国商用”计划,
- 05-15二十年未遇的强烈地磁暴来袭