My first revoke - Mailing list pgsql-general

From A B
Subject My first revoke
Date
Msg-id dbbf25900809250851m6125cf1ahcbf981da169d3ad0@mail.gmail.com
Whole thread Raw
Responses Re: My first revoke  ("Fernando Moreno" <azazel.7@gmail.com>)
List pgsql-general
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?

pgsql-general by date:

Previous
From: Marcus Engene
Date:
Subject: regexp_replace() [noindex] thing
Next
From: Tom Lane
Date:
Subject: Re: how can I find out the numeric directory name of each database in PostgreSQL 8.3