ITPEC Textbook
Reading settings
Theme
Reading mode

Guest settings stay on this device. Sign in to sync reader settings.

Contents
Chapter 4 · DatabasePractice

LEARN WITH HARU

Video Lesson တွေက Haru အတန်းသားတွေအတွက်ပါ

Haru ရဲ့ ITPEC FE Full Course မှာ ယခု သင်ခန်းစာတွေကို တစ်ခုချင်း တစ်ကြောင်းချင်း အသေးစိတ်ရှင််ရှင်းပြထားပါတယ်

အခြေခံ မရှိတဲ့ ကျောင်းသားများစွာဟာလည်း ဒီ Course နဲ့ ပဲ အောင်မြင်ကုန်ကြပါပြီ

အတန်းမအပ်သေးပဲ Haru ဆီမှာ အစမ်းသင်ကြည့်ချင်ပါသလား?

ဒီကိုနှိပ်ပါITPEC FE Full Course အကြောင်းသိရန် ဒီကိုနှိပ်ပါ

သင်တန်းသားတွေရဲ့ စကားသံများ

သင်တန်းသားတွေရဲ့ စကားသံများ
Learning toolsProgress & bookmarks

Current section

2-1-4 Definition of Access Right

p. 265

Progress

Not marked complete

Progress and bookmarks

p. 265

2-1-4 Definition of Access Right

Access right is the right (i.e., processing privilege) for each user to use a database. Setting access right is useful for data security protection. GRANT statement is used for defining access right.

Original textbook table, example or syntax box, with its complete original layout. Source text: GRANT Privilege 1, Privilege 2, ∙∙∙ ON Table Name TO Identifier • The following access rights can be defined. Type of Privilege Meaning Permission to refer to the database SELECT Permission to add (i.e., insert) data in the database INSERT Permission to delete data from the database DELETE Permission to update data in the database UPDATE Permission to redefine the database REFERENCES
p. 265 · Enlarge

p. 266

Original textbook table, example or syntax box, with its complete original layout. Source text: ALL PRIVILEGES All permission related to the database Note: Identifier uniquely specifies the intended person who is granted the permission.
p. 266 · Enlarge

ex04: Set the permission to refer and update the “Student” table in the identifier “EducationAffairsOffice”.

Original SQL worked example with its complete source code, indentation, punctuation, source frame and any attached original notes. Source text: GRANT SELECT, UPDATE ON Student TO EducationAffairsOffice
p. 266 · Enlarge

REVOKE statement is used for canceling the defined (i.e., granted) permission.

Original textbook table, example or syntax box, with its complete original layout. Source text: REVOKE Privilege 1, Privilege 2, ••• ON Table name TO Identifier
p. 266 · Enlarge

Section progress

Original chapter exercises

Original chapter exercises →

New FE Textbook Vol.1 · IT Fundamentals · First Edition, April 2015

Figure

Open original ↗