RE: User Privileges

Thank you..

Niral
-----Original Message-----
From: Dan Wilson [mailto:phpPgAdmin@acucore.com]
Sent: Tuesday, December 26, 2000 1:25 PM
To: Niral Trivedi; pgsql-general@postgresql.org
Subject: Re: [GENERAL] User Privileges


> For example I have 5 tables in database A. And now I want to give
> SELECT/UPDATE/INSERT privileges to a user to all 5 tables. But according
to
> documentation, I have to execute 'GRANT' query 3 times(for
> select/update/insert) per table. meaning total of 15 times!!!!

That's incorrect... you can do it all in one statement:

GRANT select,update,insert TO "<username>" ON table_1,table_2,table_3,etc

http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm

-Dan