How do I retrieve this privilages?
I want to disable menu-options within a program. For that I have to
retrieve the privilages for some tables.
gr,
Willem
----- Original Message -----
From: "Dan Wilson" <phpPgAdmin@acucore.com>
To: "Niral Trivedi" <niral.trivedi@insage.com>;
<pgsql-general@postgresql.org>
Sent: Tuesday, December 26, 2000 7:25 PM
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
>
>
>