So I have created a role
create role my_role with NOSUPERUSER NOCREATEDB NOCREATEROLE LOGIN
ENCRYPTED PASSWORD 'secret';
Now I wish to grant only select for this role on some tables.
So I do
revoke all privileges on table X from my_role;
and i do this for all my tables (X is table name) ?
and then
grant select on table X to my_role;
for all tables?