Oracle數(shù)據(jù)庫復(fù)雜度設(shè)置圖文教程
概述:
Oracle的復(fù)雜度通過參數(shù)PASSWORD_VERIFY_FUNCTION設(shè)置,通常該參數(shù)使用數(shù)據(jù)庫自帶的腳本utlpwdmg.sql配置,不同版本的數(shù)據(jù)庫腳本自帶的復(fù)雜度也不盡相同,當然也可以自己配置腳本文件。
以下測試使用的是Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
一、查看復(fù)雜度
select * from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';
這時看到能配置復(fù)雜度的有兩個函數(shù):默認的DEFAULT、系統(tǒng)版本自帶的ORA_STIG_PROFILE。
查看用戶使用的復(fù)雜度函數(shù):
select username,profile,account_status from dba_users;
在此,我的測評數(shù)據(jù)庫都是使用DEAULT。
根據(jù)圖1的結(jié)果,DEFAULT沒有復(fù)雜度設(shè)置(NULL)。
二、驗證復(fù)雜度
測試復(fù)雜度,在此使用賬戶LHX,修改密碼。
修改成功。驗證可知,測試賬戶LHX未配置復(fù)雜度。
三、應(yīng)用utlpwdmg.sql,配置數(shù)據(jù)庫復(fù)雜度
服務(wù)器使用sysdba賬戶登錄數(shù)據(jù)庫,輸入
@utlpwdmg.sql
四、查看復(fù)雜度
五、驗證復(fù)雜度
使用賬戶LHX,修改密碼。
備注:報錯原因,經(jīng)查閱是特殊字符只能使用指定字符_,$和#。
驗證可知,該數(shù)據(jù)庫版本自帶的復(fù)雜度ORA12C_VERIFY_FUNCTION是至少8位字符,由字母、數(shù)字、特殊字符組成。
六、查看自帶的復(fù)雜度腳本
服務(wù)器切換Oracle賬戶,進入$ORACLE_HOME/rdbms/admin文件夾下,可以看到utlpwdmg.sql
[root@localhost ~]# su - oracle [oracle@localhost ~]$ cd $ORACLE_HOME/rdbms/admin [oracle@localhost admin]$
[oracle@localhost admin]$ cat utlpwdmg.sql Rem Rem $Header: rdbms/admin/utlpwdmg.sql /main/13 2016/01/04 21:20:04 sumkumar Exp $ Rem Rem utlpwdmg.sql Rem Rem Copyright (c) 2006, 2015, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem utlpwdmg.sql - script for Default Password Resource Limits Rem Rem DESCRIPTION Rem This is a script for enabling the password management features Rem by setting the default password resource limits. Rem Rem NOTES Rem This file contains a function for minimum checking of password Rem complexity. This is more of a sample function that the customer Rem can use to develop the function for actual complexity checks that the Rem customer wants to make on the new password. Rem Rem MODIFIED (MM/DD/YY) Rem sumkumar 12/15/15 - Bug 22369990: Make all PVFs as common objects Rem so as to make them available inside PDBs Rem yanlili 09/18/15 - Fix bug 20603202: Handle quoted usernames if Rem called directly Rem hmohanku 02/17/15 - bug 20460696: add long identifier support Rem sumkumar 12/26/14 - Proj 46885: set inactive account time to Rem UNLIMITED for DEFAULT profile Rem jkati 10/16/13 - bug#17543726 : remove complexity_check, Rem string_distance, ora12c_strong_verify_function Rem since we now provide them by default with new db Rem creation Rem skayoor 10/26/12 - Bug 14671375: Execute privilege on pwd verify Rem func Rem jmadduku 07/30/12 - Bug 13536142: Re-organize the code Rem jmadduku 12/02/11 - Bug 12839255: Compliant Password Verify functions Rem jmadduku 01/21/11 - Proj 32507: Add a new password verify function Rem STIG_verify_function and enhance functionality of Rem code that checks distance between old and new Rem password Rem asurpur 05/30/06 - fix - 5246666 beef up password complexity check Rem nireland 08/31/00 - Improve check for username=password. #1390553 Rem nireland 06/28/00 - Fix null old password test. #1341892 Rem asurpur 04/17/97 - Fix for bug479763 Rem asurpur 12/12/96 - Changing the name of password_verify_function Rem asurpur 05/30/96 - New script for default password management Rem asurpur 05/30/96 - Created Rem -- 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 provided. Rem ************************************************************************* Rem BEGIN Password Management Parameters Rem ************************************************************************* -- 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 LIMIT PASSWORD_LIFE_TIME 180 PASSWORD_GRACE_TIME 7 PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED FAILED_LOGIN_ATTEMPTS 10 PASSWORD_LOCK_TIME 1 INACTIVE_ACCOUNT_TIME UNLIMITED PASSWORD_VERIFY_FUNCTION ora12c_verify_function; /** The below set of password profile parameters would take into consideration recommendations from Center for Internet Security[CIS Oracle 11g]. ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 90 PASSWORD_GRACE_TIME 3 PASSWORD_REUSE_TIME 365 PASSWORD_REUSE_MAX 20 FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 1 PASSWORD_VERIFY_FUNCTION ora12c_verify_function; */ /** The below set of password profile parameters would take into consideration recommendations from Department of Defense Database Security Technical Implementation Guide[STIG v8R1]. ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 60 PASSWORD_REUSE_TIME 365 PASSWORD_REUSE_MAX 5 FAILED_LOGIN_ATTEMPTS 3 PASSWORD_VERIFY_FUNCTION ora12c_strong_verify_function; */ Rem ************************************************************************* Rem END Password Management Parameters Rem *************************************************************************
本文參考:
ORACLE密碼復(fù)雜度校驗?zāi)_本utlpwdmg.sql解析
oracle數(shù)據(jù)庫設(shè)置密碼復(fù)雜度,Oracle EBS 數(shù)據(jù)庫密碼復(fù)雜度設(shè)置
到此這篇關(guān)于Oracle數(shù)據(jù)庫復(fù)雜度設(shè)置的文章就介紹到這了,更多相關(guān)Oracle復(fù)雜度設(shè)置內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
Oracle Arraysize設(shè)置對于邏輯讀的影響實例分析
這篇文章主要介紹了Oracle Arraysize設(shè)置對于邏輯讀的影響實例分析,通過設(shè)置Arraysize大幅減少了邏輯讀的次數(shù)和網(wǎng)絡(luò)往返次數(shù),需要的朋友可以參考下2014-07-07Oracle數(shù)據(jù)庫統(tǒng)計信息方法詳解
這篇文章主要介紹了如何查看和收集Oracle數(shù)據(jù)庫中的統(tǒng)計信息,包括表、索引和列的統(tǒng)計信息,介紹了DBMS_STATS包的功能和使用方法,以及如何通過分析和刪除統(tǒng)計信息來優(yōu)化數(shù)據(jù)庫性能,需要的朋友可以參考下2024-12-12深入Oracle的left join中on和where的區(qū)別詳解
本篇文章是對Oracle的left join中on和where的區(qū)別進行了詳細的分析介紹,需要的朋友參考下2013-06-06Oracle數(shù)據(jù)庫創(chuàng)建存儲過程的示例詳解
這篇文章主要介紹了Oracle數(shù)據(jù)庫創(chuàng)建存儲過程的示例詳解,存儲過程是事先經(jīng)過編譯并存儲在數(shù)據(jù)庫中的一段SQL語句的集合,調(diào)用存儲過程可以簡化應(yīng)用開發(fā)人員的很多工作。對此感興趣可以了解一下2020-07-07Oracle Session每日統(tǒng)計功能實現(xiàn)
客戶最近有這樣的需求,想通過統(tǒng)計Oracle數(shù)據(jù)庫活躍會話數(shù),并記錄在案,利用比對歷史的活躍會話的方式,實現(xiàn)對系統(tǒng)整體用戶并發(fā)量有大概的預(yù)估,本文給大家分享具體實現(xiàn)方法,感興趣的朋友一起看看吧2022-02-02在ORACLE中SELECT TOP N的實現(xiàn)方法
這篇文章主要介紹了在ORACLE中SELECT TOP N的實現(xiàn)方法,非常不錯,具有參考借鑒價值,需要的朋友參考下2017-01-01Oracle 11g數(shù)據(jù)庫使用expdp每周進行數(shù)據(jù)備份并上傳到備份服務(wù)器
這篇文章主要介紹了Oracle 11g數(shù)據(jù)庫使用expdp每周進行數(shù)據(jù)備份并上傳到備份服務(wù)器,本文給大家介紹的非常詳細,對大家的學(xué)習(xí)或工作具有一定的參考借鑒價值,需要的朋友可以參考下2022-06-06