$1.$ Start by enabling MySQL Enterprise Firewall on your MySQL server using mysql workbench.

$2.$ Create firewall groups for different types of users, such as administrators,

insiders, guest users and individual clients. Develop firewall rules to allow

common queries necessary for application functionality of different groups and

isolated queries for individual clients

a$.$ Users in the administrators group should be the firewall administrators

and exempted from all rules.

b$.$ Users in the insiders group which comprises three users insider$1,$

insider$2,$ insider$3$ can select staff details update all columns of a

particular staff except username and password.

c$.$ Users in the clients group which comprises three users client$1,$ client$2,$

client$3$ can select the views authors$\_$info and film$\_$list

d$.$ There are two guest users guest$1$ and guest$2.$ guest$1$ can select

payment table and update amount and payment$\_$date. guest$2$ select a

particular actor details from actor table of sakila schema, and update

first$\_$name and last$\_$name of a particular actor.

Write SQL queries against the Sakila database that match the criteria of your firewall

rule and verify that allowed queries execute successfully and that blocked queries are

rejected with appropriate error messages.

Ensure that firewall rules complement user privileges and permissions to enforce

comprehensive security policies.

Show the output of mysql quieres with proper output pics and also show by connecting to different users and then show the ouptut that it is implementing.

Also show the what group will be in RECORDING mode in firewall while creating whitelist$/$allow list for a particular user.