Orcale Tutorial Content
Loading...
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
Automating Tasks with the Scheduler
(Privileges) ﺍﻟﺼﻼﺤﻴﺎﺕ
ﺤﺘﻲ ﻴﺘﻤﻜﻥ ﺍﻟﻤﺴﺘﺨﺩﻡ ﻤﻥ ﺇﻨﺸﺎﺀ (Jobs & Schedules & Programs) ﻓﺈﻨﻪ ﻴﺤﺘﺎﺝ ﻟﻠﺼﻼﺤﻴﺎﺕ ﻤﻥ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﻴﻘﻭﻡ ﺒﺘﻠﻙ ﺍﻟﻤﻬﺎﻡ،
ﻭﻫﻨﺎﻙ ﺍﻟﻌﺩﻴﺩ ﻤﻥ ﺍﻟﺼﻼﺤﻴﺎﺕ ﺍﻟﺘﻲ ﺘﺘﻌﻠﻕ ﺒﻤﻭﻀﻭﻉ ﺍﻟﺠﺩﻭﻟﺔ:
CREATE JOB: ﺘﺴﻤﺢ ﻟﻠﻤﺴﺘﺨﺩﻡ ﺒﺈﻨﺸﺎﺀ (Jobs & Schedules & Programs).
CREATE ANY JOB: ﺘﺴﻤﺢ ﻟﻠﻤﺴﺘﺨﺩﻡ ﺒﺈﻨﺸﺎﺀ ﺍلJobs ﻓﻲ Schema ﺃﺨﺭﻱ.
EXECUTE ANY PROGRAM: ﺘﺴﻤﺢ ﻟﻠﻤﺴﺘﺨﺩﻡ ﺒﺎﺴﺘﻌﻤﺎل Program ﻤﻭﺠﻭﺩ ﻓﻲ Schema ﺃﺨﺭﻱ.
EXECUTE ANY CLASS: ﺘﺴﻤﺢ ﻟﻠﻤﺴﺘﺨﺩﻡ ﺒﺎﺴﺘﻌﻤﺎل Class Job ﻤﻭﺠﻭﺩ ﻓﻲ Schema ﺃﺨﺭﻱ.
MANAGE SCHEDULER: ﺘﺴﻤﺢ ﻟﻠﻤﺴﺘﺨﺩﻡ ﺒﺈﻨﺸﺎﺀ (Job & Classes & Windows).
(EXECUTE ON (JOB, PROGRAM or CLASS: ﻭﻫﻲ ﻹﻋﻁﺎﺀ ﺍﻟﻤﺴﺘﺨﺩﻡ ﺼﻼﺤﻴﺔ ﺍﻹﺴﺘﺨﺩﺍﻡ ﻭﺍﻟﺘﻨﻔﻴﺫ ﻟﻜﺎﺌﻥ ﻤﻌﻴﻥ.
(ALTER ON (JOB, PROGRAM or CLASS: ﺘﺴﻤﺢ ﻟﻠﻤﺴﺘﺨﺩﻡ ﺒﺈﺠﺭﺍﺀ ﺘﻌﺩﻴﻼﺕ ﻓﻲ ﻜﺎﺌﻥ ﻤﻌﻴﻥ.
-----------------------------------------------