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