Re: Granting any privilege for a specific set of tables in postgres in a single shot!..

Hi all,

Hope my mail finds you in good time. I have a question in regards to
"Grant" command.

How can I grant a particular privilege to a specific set of objects(tables)
in a single shot ?

FYI, please consider the following scenario. I have a database "abc" with
users as "u1","u2","u3","u4". And there are 1500 tables in my database.

Now my requirement is to grant select on 800 tables(specific set of tables)
which suits my requirement. I know that I can use the below statement 800
times.

grant select on table1 to u1;
grant select on table2 to u1;
.
.
.
.
.
.
grant select on table800 to u1;

My question is can't I do it in a single shot? Can I fit some select query
which passes the table name as a parameter in the middle of the grant
statement?

Please advice.

Thanks in Advance.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html