Muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti laboratoriya ish

O‘ZBEKISTON RESPUBLIKASI RAQAMLI TEXNOLOGIYALAR VAZIRLIGI

MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI

Laboratoriya ISH


Guruh: DBM001-1
Fan nomi: Ma’lumotlar bazasini boshqarish
Bajardi: Elyor Nigmonov
Tekshirdi: Sodiqov Vali
Toshkent 2023
DCL bo'limi yordamida foydalanuvchilarga rollar va imtiyoz qo'shish uchun bir nechta buyruqlar mavjud. Asosiy buyruqlar quyidagilar:
"Kompyuter uskunalarini ta'mirlash va dasturiy ta'minotni o'rnatish va qo'llab-quvvatlash tashkiloti" nomli mavzu bo'yicha DCL bo'limi buyruqlari yordamida menejerlikni amalga oshirishni ko'rib chiqamiz. Bu misolni o'zgartiramiz:


Foydalanuvchilarni yaratish:

CREATE USER IT_support IDENTIFIED BY secure_password;

CREATE USER Hardware_tech IDENTIFIED BY strong_password;
CREATE USER Software_tech IDENTIFIED BY robust_password;


Rollarni yaratish:
CREATE ROLE Support_staff;
CREATE ROLE Hardware_team;
CREATE ROLE Software_team;
Rollarni foydalanuvchilarga biriktirish:
GRANT Support_staff TO IT_support;
GRANT Hardware_team TO Hardware_tech;
GRANT Software_team TO Software_tech;
Imtiyozlarni o'rnatish:
GRANT UPDATE, SELECT ON Hardware_inventory TO Hardware_team;
GRANT UPDATE, SELECT ON Software_inventory TO Software_team;
GRANT EXECUTE ON Repair_procedures TO Support_staff;
Foydalanuvchilardan rollarni olib tashlash:
REVOKE Support_staff FROM IT_support;
REVOKE Hardware_team FROM Hardware_tech;
REVOKE Software_team FROM Software_tech;
Foydalanuvchilarni o'chirish:
DROP USER IT_support;
DROP USER Hardware_tech;
DROP USER Software_tech;
Rollarni o'chirish:
DROP ROLE Support_staff;
DROP ROLE Hardware_team;
DROP ROLE Software_team;
Bu buyruqlar orqali siz o'zingizning menejerlik strukturangizni yaratishingiz mumkin va foydalanuvchilarga aniq imtiyozlarni taqsimlash orqali ularni mukofotlash va himoyalash imkoniyatiga ega bo'lasiz.