oracle數(shù)據(jù)庫的安全與管理培訓(xùn)教材-文庫吧
2025-02-02 12:26 本頁面
【正文】 measured in bytes (for MTS only)在會話層設(shè)置資源限制 資源CPU_PER_CALLLOGICAL_READS_PER _CALL說明CPU time per call in hundredths of secondsNumber of data blocks在調(diào)用層設(shè)置資源限制為用戶分配資源文件CREATE USER user3 IDENTIFIED BY user3DEFAULT TABLESPACE data01TEMPORARY TABLESPACE tempQUOTA unlimited ON data01 PROFILE developer_prof。ALTER USER scott PROFILE developer_prof。啟用資源限制– 將初始化參數(shù) RESOURCE_LIMIT設(shè)置成TRUE或– 使用帶有啟用參數(shù)的 ALTER SYSTEM命令強制資源限制ALTER SYSTEM SET RESOURCE_LIMIT=TRUE。 修改環(huán)境文件ALTER PROFILE default LIMITSESSIONS_PER_USER 5CPU_PER_CALL 3600IDLE_TIME 30。刪除環(huán)境文件DROP PROFILE developer_prof。DROP PROFILE developer_prof CASCADE。查看資源限制 DBA_USERS profile usernameDBA_PROFILES profile resource_name resource_type (KERNEL) limit口令管理用戶用戶口令到期口令到期和時效和時效口令確認口令確認口令歷史口令歷史 帳戶鎖帳戶鎖建立環(huán)境建立環(huán)境文件文件啟用口令管理– 使用環(huán)境文件并分配給用戶來建立口令管理– 使用 CREATE USER或 ALTER USER加鎖 ,解鎖 ,和期滿帳戶– 既使實例的 RESOURCE_LIMIT的設(shè)置是FALSE,口令限制仍始終被強制 創(chuàng)建環(huán)境文件 :口令設(shè)置CREATE PROFILE grace_5 LIMIT FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LIFE_TIME 30 PASSWORD_REUSE_TIME 30 PASSWORD_VERIFY_FUNCTION verify_function PASSWORD_GRACE_TIME 5。口令設(shè)置ParameterFAILED_LOGIN_ATTEMPTSPASSWORD_LOCK_TIME PASSWORD_LIFE_TIMEPASSWORD_GRACE_TIMEDescriptionNumber of failed login attempts before lockout of the accountNumber of days for which the account remains locked upon password expirationLifetime of the password in days after which the password expiresGrace period in days for changing the password after the first successful login after the password has expired口令設(shè)置ParameterPASSWORD_REUSE_TIMEPASSWORD_REUSE_MAXPASSWORD_VERIFY_FUNCTIONDescriptionNumber of days before a password can be reusedMaximum number of t
語文相關(guān)推薦
鄂ICP備17016276號-1