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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
