Create role analyst (drop it first if it exists), grant it SELECT on books, then check has_table_privilege('analyst','books','SELECT') as can_read.

Answer

DROP ROLE IF EXISTS analyst; CREATE ROLE analyst; GRANT SELECT ON books TO analyst; SELECT has_table_privilege('analyst', 'books', 'SELECT') AS can_read;