On 25/09/2008 19:24, Fernando Moreno wrote:
> only have to grant select on the tables you want, and yes, one by one.
If you use pgAdmin, it has a wizard for doing a bunch of objects in one go.
Ray.
--
Raymond O'Donnell, Director of
Hi, first of all, a new role doesn't have any privilege on any table (every
type of database object has different default privileges), so you only have
to grant select on the tables you want, and yes, one by one.
You can also grant or revoke privileges this way: grant select on
table1,table2,table
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) ?
