Users, Roles, Groups

Lets understand roles and permissions with a few practical questions. QN 1: Create a login role that can only read from film table CREATE ROLE report_user LOGIN; GRANT SELECT ON film TO report_user; we create a user called report_user and give it only SELECT permission on the film table. So it can read data but cant modify anything. 2: Accessing customer table gives permission denied fix it GRANT SELECT ON customer TO report_user; The error happens because report_user doesnt have access to the c