Users, Roles, Groups

Create a report_user role with read access only on film table
Create a login role and grant SELECT permission only on film table

Fix permission denied when accessing customer table
Grant SELECT permission on customer table to report_user

Allow report_user to see only selected columns from customer
Revoke full access and grant SELECT only on customer_id first_name last_name columns

Create support_user with limited permissions
Grant SELECT on customer and UPDATE only on email column and do not give DELETE permission

Remove SELECT access on film from report_user
Revoke SELECT permission on film table from report_user

Create readonly_group with read access on all tables
Create role and grant SELECT permission on all tables in the database

Add analyst users to readonly_group
Create analyst1 and analyst2 and assign them to readonly_group