Re: [GENERAL] Granting Privileges in Postgres

2011-08-08 Thread Guillaume Lelarge
On Mon, 2011-08-08 at 11:42 +0530, Adarsh Sharma wrote: > Guillaume Lelarge wrote: > > On Mon, 2011-08-08 at 10:28 +0530, Adarsh Sharma wrote: > > > >> Dear all, > >> > >> Today I researched on giving privileges in Postgres databases. I have 4 > >> databases and near about 150 tables, 50-60 seq

Re: [GENERAL] Granting Privileges in Postgres

2011-08-07 Thread Adarsh Sharma
Guillaume Lelarge wrote: On Mon, 2011-08-08 at 10:28 +0530, Adarsh Sharma wrote: Dear all, Today I researched on giving privileges in Postgres databases. I have 4 databases and near about 150 tables, 50-60 sequences and also some views in it. I want to give privileges to a new user in al

Re: [GENERAL] Granting Privileges in Postgres

2011-08-07 Thread Guillaume Lelarge
On Mon, 2011-08-08 at 10:28 +0530, Adarsh Sharma wrote: > Dear all, > > Today I researched on giving privileges in Postgres databases. I have 4 > databases and near about 150 tables, 50-60 sequences and also some views > in it. > > I want to give privileges to a new user in all these objects. I

Re: [GENERAL] Granting Privileges in Postgres

2011-08-07 Thread John R Pierce
On 08/07/11 9:58 PM, Adarsh Sharma wrote: Dear all, Today I researched on giving privileges in Postgres databases. I have 4 databases and near about 150 tables, 50-60 sequences and also some views in it. I want to give privileges to a new user in all these objects. I created a function for

[GENERAL] Granting Privileges in Postgres

2011-08-07 Thread Adarsh Sharma
Dear all, Today I researched on giving privileges in Postgres databases. I have 4 databases and near about 150 tables, 50-60 sequences and also some views in it. I want to give privileges to a new user in all these objects. I created a function for that but don't know how to give privileges