Orcale Tutorial Content
Getting Started - البدء مع إدارة قواعد البيانات
Oracle Architectural Components - مكونات قاعدة البيانات أوركل
Installing Oracle Database - تثبيت الأوركل
Creating and Configuring Database - إنشاء قاعدة البيانات
Controlling The Database -التحكم في قاعدة البيانات
Administrating Users - إدارة المستخدمين
Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
Oracle Net Services & Database Link & Metrlized Viewِ
Undo Management & Flashback Technology
Managing Shared Servers
Using Globalization Support
Logical Backup & Recovery
Physical Backup & Recovery
Recovery Manager (RMAN)
Managing Resources
Automating Tasks with the Scheduler
Dealing with Locking
Diagnostic Sources
Dealing With Database Corruption
Managing & Monitoring Memory
Performance Tunning
Managing Resources
Privileges & Resource Manager
ﺍﻟﺼﻼﺤﻴﺎﺕ ﻭﺍلResource Manager:
ﺴﻨﺴﺘﺨﺩﻡ ﻫﻨﺎ ﺍﻟﺤﺯﻤﺔ DBMS_RESOURCE_MANAGER_PRIVS ﻭﺘﺤﺘﻭﻱ ﻫﺫﻩ ﺍﻟﺤﺯﻤﺔ ﻋﻠﻲ ﺍﺭﺒﻌﺔ ﺍﺠﺭﺍﺀﺍﺕ ﻭﻫﻲ:
DESC DBMS_RESOURCE_MANAGER_PRIVS; |
1- GRANT_SWITCH_CONSUMER_GROUP: ﻭﻴﺴﺘﺨﺩﻡ ﻫﺫﺍ ﺍﻹﺠﺭﺍﺀ ﻟﻤﻨﺢ ﺍﻟﻤﺴﺘﺨﺩﻡ ﺼﻼﺤﻴﺔ ﺍﻹﻨﻀﻤﺎﻡ لGroup Consumer،ﻭﺫﻟﻙ ﺒﻌﺩ ﺘﺤﺩﻴﺩ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻭﺍلGroup ﻓﻲ ﺍﻹﺠﺭﺍﺀ،
والوضع الإفتراضي ﺃﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻻ ﻴﺴﺘﻁﻴﻊ ﺍﻟﺘﺤﻭل لGroup ﻤﻌﻴﻨﺔ ﻤﺎ ﻟﻡ ﻴﻤﻨﺢ ﺼﻼﺤﻴﺔ ﻟﺫﻟﻙ ﻭﻟﻨﻔﺘﺭﺽ ﺍﻻﻥ ﺃﻨﻨﺎ ﻨﺭﻴﺩ ﻤﻨﺢ ﺍﻟﻤﺴﺘﺨﺩﻡ OBAY ﺼﻼﺤﻴﺔ ﺍﻹﻨﻀﻤﺎﻡ لNEW_GROUP CONSUMER GROUP.
DECLARE GRANTEE_NAME VARCHAR2(200); CONSUMER_GROUP VARCHAR2(200); GRANT_OPTION BOOLEAN; BEGIN GRANTEE_NAME := 'OBAY'; CONSUMER_GROUP := 'NEW_GROUP'; GRANT_OPTION := FALSE; SYS.DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONS UMER_GROUP ( GRANTEE_NAME, CONSUMER_GROUP, GRANT_OPTION ); COMMIT; END; |
ﺍﻻﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ OBAY ﻴﺴﺘﻁﻴﻊ ﺍﻻﻨﻀﺎﻡ ﻟﻠﻤﺠﻤﻭﻋﺔ NEW_GROUP CONSUMER GROUP.
ﻭﻟﻜﻥ ﻻ ﻴﺴﺘﻁﻴﻊ ﺍﻻﻨﻀﻤﺎﻡ ﻟﻤﺠﻤﻭﻋﺔ ﻻ ﻴﻤﻠﻙ ﺼﻼﺤﻴﺔ ﺍﻻﻨﻀﻤﺎﻡ ﻟﻬﺎ.
2 - GRANT_SYSTEM_PRIVILEGE:
ﻭﻫﺫﺍ ﺍﻹﺠﺭﺍﺀ ﻟﻤﻨﺢ ﺼﻼﺤﻴﺎﺕ ﺇﺩﺍﺭﺓ ﺍلResource Manager ﻟﻠﻤﺴﺘﺨﺩﻤﻴﻥ، ﺤﻴﺙ ﻴﺘﻡ ﺘﺤﺩﻴﺩ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻭﺍﻟﺼﻼﺤﻴﺔ ﺍﻟﺘﻲ ﻨﺭﻴﺩ ﻤﻨﺤﻬﺎ ﻟﻪ ﺍﺜﻨﺎﺀ ﺘﻨﻔﻴﺫ ﺍﻹﺠﺭﺍﺀ.
DECLARE GRANTEE_NAME VARCHAR2(200); PRIVILEGE_NAME VARCHAR2(200); ADMIN_OPTION BOOLEAN; BEGIN GRANTEE_NAME := 'OBAY'; PRIVILEGE_NAME := 'ADMINISTER_RESOURCE_MANAGER'; ADMIN_OPTION := FALSE; SYS.DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE ( GRANTEE_NAME, PRIVILEGE_NAME, ADMIN_OPTION ); COMMIT; END; |
ﻤﻨﺤﻨﺎ ﺼﻼﺤﻴﺔ ﺍﺩﺍﺭﺓ ﺍلManager Resource ﻟﻠﻤﺴﺘﺨﺩﻡ OBAY.
3- REVOKE_SWITCH_CONSUMER_GROUP: ﻨﺴﺘﻁﻴﻊ ﻤﻥ ﺨﻼل ﻫﺫﺍ ﺍﻹﺠﺭﺍﺀ ﺴﺤﺏ ﺼﻼﺤﻴﺔ ﺍﻹﻨﻀﻤﺎﻡ ﻟﻤﺠﻤﻭﻋﺔ ﻤﻌﻴﻨﺔ ﻤﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ ﺍﻟﺫﻱ ﻴﻤﻠﻙ ﻫﺫﻩ ﺍﻟﺼﻼﺤﻴﺔ
ﻭﺍﻟﺘﻲ ﺘﻤﻨﺢ ﻤﻥ ﺨﻼل ﺍﻹﺠﺭﺍﺀ GRANT_SWITCH_CONSUMER_GROUP.
DECLARE REVOKEE_NAME VARCHAR2(200); CONSUMER_GROUP VARCHAR2(200); BEGIN REVOKEE_NAME := 'OBAY'; CONSUMER_GROUP := 'NEW_GROUP'; SYS.DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SWITCH_CONSU MER_GROUP ( REVOKEE_NAME, CONSUMER_GROUP ); COMMIT; END; |
4 - REVOKE_SYSTEM_PRIVILEGE: ﻭﻫﻭ ﺇﺠﺭﺍﺀ ﻟﺴﺤﺏ ﺼﻼﺤﻴﺎﺕ ﺇﺩﺍﺭﺓ ﺍلResource Manager ﻤﻥ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ،
ﻭﻟﻨﻔﺘﺭﺽ ﻨﺭﻴﺩ ﺴﺤﺏ ﺼﻼﺤﻴﺔ ﺇﺩﺍﺭﺓ ﺍل Resource Manager ﻤﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ OBAY ﺍﻟﺫﻱ ﻗﻤﻨﺎ ﺒﻤﻨﺤﻪ ﺍﻴﺎﻫﺎ ﻤﻥ ﻗﺒل.
DECLARE REVOKEE_NAME VARCHAR2(200); PRIVILEGE_NAME VARCHAR2(200); BEGIN REVOKEE_NAME := 'OBAY'; PRIVILEGE_NAME := 'ADMINISTER_RESOURCE_MANAGER'; SYS.DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVI LEGE ( REVOKEE_NAME, PRIVILEGE_NAME ); COMMIT; END; |
--------------------------------------------------