糖果派对官方网站_可以赌钱的糖果游戏_手机版
bb电子糖果派对升迁Oracle客户密码安全性的战略_oracle_脚本之家

bb电子糖果派对升迁Oracle客户密码安全性的战略_oracle_脚本之家

作者:网络编程    来源:未知    发布时间:2019-12-23 19:47    浏览量:

使用WNetAddConnection2()函数,NETRESOURCE的dwType=RESOURCETYPE_DISK,lpLocalName和lpRemoteName都赋值了,lpProvider为空;密码和顾客名都为空,无需顾客名和密码;标记位是CONNECT_UPDATE_PROFILE函数推行后再次来到值平昔是5,可是手动就能够张开分享目录访谈,也得以手动设置出来,不过函数总是实行倒闭求大神解救

环境:Oracle 11.2.0.4

     在上篇小说中,介绍了剧本参数化,继续接纳其脚本,落成获取弹出提醒框消息是或不是准确,上篇作品的地点:

客商须要:主要背景是数据库中有多数业务客户名,且由于有的客商缺乏安全意识,以至一向将和谐的密码设置为和客户名相近,如今客商愿意密码设置不要过于简短,最最少别和客商名相似或相通就好。

    1.第风华正茂分明流程,获抽出来的音讯要和预期的不利音信比较,所以把预期新闻先规划好,有的提醒音信相比长,所以用到正则表达式 ,只要匹配当中的风流罗曼蒂克有个别就能够。(纵然把提示音信写的全的话,就毫无正则表明式,自个儿选用)  

1.官方技术方案

      登入测量检验用例操作:

实际上Oracle提供有一个要命好用的安全校验函数,来升高顾客密码的眼花缭乱。这么些在前头的稿子《Oracle 11g 安全加固》中的“1.8.数据库密码安全性校验函数”章节就已经有了适当的消除方案,宗旨内容如下:

bb电子糖果派对,                 客户名                                密码                          提醒音讯

select limit from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION';prompt =============================prompt == 8.数据库密码安全性校验函数 prompt =============================prompt 执行创建安全性校验函数的脚本@?/rdbms/admin/utlpwdmg.sql select limit from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION';

       (1)客商名叫空                       密码准确                  Please enter agent name   

2.删减版解决方案

      (2)客户名相当不够4个字节             密码正确                     at least 4    //这里选用相配字符串

下面那几个自带的安全性校验函数对检查过度严俊,而客商近日的必要就独有叁个,分化意密码和客户名完全相近或过度相通就足以了。于是乎,作者就从这一个剧本中找到那项必要,把别的权且不需求的大器晚成都部队分全部去掉。那样,就得到了如下的删减版脚本:

      (3)顾客名科学                       密码准确                                    //正确登入此处为空

RemRem $Header: rdbms/admin/utlpwdmg1.sql /st_rdbms_11.2.0/1 2013/01/31 01:34:11 skayoor Exp $RemRem utlpwdmg.sqlRemRem Copyright  2006, 2013, Oracle and/or its affiliates. Rem All rights reserved. RemRem NAMERem utlpwdmg.sql - script for Default Password Resource LimitsRemRem DESCRIPTIONRem This is a script for enabling the password management featuresRem by setting the default password resource limits.RemRem NOTESRem This file contains a function for minimum checking of passwordRem complexity. This is more of a sample function that the customerRem can use to develop the function for actual complexity checks that the Rem customer wants to make on the new password.RemRem MODIFIED Rem skayoor 01/17/13 - Backport skayoor_bug-14671375 from mainRem asurpur 05/30/06 - fix - 5246666 beef up password complexity check Rem nireland 08/31/00 - Improve check for username=password. #1390553Rem nireland 06/28/00 - Fix null old password test. #1341892Rem asurpur 04/17/97 - Fix for bug479763Rem asurpur 12/12/96 - Changing the name of password_verify_functionRem asurpur 05/30/96 - New script for default password managementRem asurpur 05/30/96 - CreatedRem-- This script sets the default password resource parameters-- This script needs to be run to enable the password features.-- However the default resource parameters can be changed based -- on the need.-- A default password complexity function is also provided.-- This function makes the minimum complexity checks like-- the minimum length of the password, password not same as the-- username, etc. The user may enhance this function according to-- the need.-- This function must be created in SYS schema.-- connect sys/ as sysdba before running the scriptCREATE OR REPLACE FUNCTION verify_function_11G_WJZYY(username varchar2, password varchar2, old_password varchar2) RETURN boolean IS n boolean; m integer; differ integer; isdigit boolean; ischar boolean; ispunct boolean; db_name varchar2; digitarray varchar2; punctarray varchar2; chararray varchar2; i_char varchar2; simple_password varchar2; reverse_user varchar2;BEGIN digitarray:= '0123456789'; chararray:= 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'; -- Check if the password is same as the username or username IF NLS_LOWER = NLS_LOWER THEN raise_application_error(-20002, 'Password same as or similar to user'); END IF; FOR i IN 1..100 LOOP i_char := to_char; if NLS_LOWER|| i_char = NLS_LOWER THEN raise_application_error(-20005, 'Password same as or similar to user name '); END IF; END LOOP; -- Everything is fine; return TRUE ; RETURN;END;/GRANT EXECUTE ON verify_function_11G_WJZYY TO PUBLIC;-- This script alters the default parameters for Password Management-- This means that all the users on the system have Password Management-- enabled and set to the following values unless another profile is -- created with parameter values set to different value or UNLIMITED -- is created and assigned to the user.ALTER PROFILE DEFAULT LIMITPASSWORD_LIFE_TIME 180PASSWORD_VERIFY_FUNCTION verify_function_11G_WJZYY;

     (4)顾客名科学                       密码为空                  Please enter password

上一篇:没有了
下一篇:没有了
友情链接: 网站地图
Copyright © 2015-2019 http://www.tk-web.com. bb电子糖果派对有限公司 版权所有