SQL ADMIN PRIVLAGES QUESTIONS. GRANTING AND REVOKING *ONLY ANSWER IF ANSWERING A

Question

SQL ADMIN PRIVLAGES QUESTIONS. GRANTING AND REVOKING *ONLY ANSWER IF ANSWERING ALL*

THANK YOU

Treasure Hunters Company have two employees, Nikki and Phil, to work with the MySQL database. Working as MySQL database administrator, provide the commands required to grant or revoke access so the following securi A. User Nikki must be able to add records to the PLAYER table (0.5 Marks) B. User Nikki must be able to remove records from the PLAYER table (0.5 Marks) C. User Phil is no longer allowed to add data to the PLAYER table (0.5 Marks) D. User Phil is no longer allowed to delete records from the PLAYER table (0.5 Marks) Assume usemames of employees Nikki and Phil are nikki and phil respectively

Explanation / Answer

A. grant INSERT on PLAYER to nikki;

B. grant DELETE on PLAYER to nikki;

C. revoke INSERT on PLAYER from phil;

D. revoke DELETE on PLAYER from phil;

Have a nice Day!

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.