Question

Task 5

Working as a Database Administrator for MySQL Treasure Hunter database, write the following commands for two employees namely Lisa and Sri to achieve the following database security requirements:

1. User Lisa is no longer allowed to add data to the Player table
2. User Lisa is no longer allowed to delete records from the Player table
3. User Sri must be able to add records to the Quest table
4. User Sri must be able to remove records from the Quest table

Assume usernames of employees namely Lisa and Sri are lisa and sri respectively.

Answer 1

Given Database : Treasure_Hunter.

Users : lisa , sri.

Table : Player, Quest .

We can make use of grant and revoke commands to complete the above requests.

A) REVOKE INSERT ON Treasure_Hunter.Player FROM 'lisa';

B) REVOKE DELETE ON Treasure_Hunter.Player FROM 'lisa';

C) GRANT INSERT ON Treasure_Hunter.Quest TO 'sri';

D) GRANT DELETE ON Treasure_Hunter.Quest TO 'sri';