SELECT * FROM information_schema.role_table_grants WHERE grantee = 'your_role_name';
GRANT SELECT ON your_table_name TO your_role_name;
/var/log/postgresql/
on Linux systems.SELECT * FROM pg_policies WHERE tablename='your_table_name';
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)