grant usage, insert, update, delete on table s.t to r;

grant connect on database d to r;
grant usage   on schema   s to r;