X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1DBFC9DCA3E for ; Wed, 1 Mar 2006 10:28:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89355-01 for ; Wed, 1 Mar 2006 10:28:05 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by postgresql.org (Postfix) with ESMTP id D861D9DC9B0 for ; Wed, 1 Mar 2006 10:27:59 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 70so143222wra for ; Wed, 01 Mar 2006 06:28:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=MRMT4o0JRkawPYnPk37k0mu2CFKVUnu3X+vHekdU2/tjmD+8f2IZJ7jdPe/35g8XvIt+OuETVpPLn3bLaqNJuMctbdrHcyw6wuNcj3Wk1WQkYsETMQmHG8xV7n6iSq9Ng9hnkJsXjHWKqNldb9zeQxztdINPmKhLsiZXiegsbFw= Received: by 10.65.81.17 with SMTP id i17mr110524qbl; Wed, 01 Mar 2006 06:28:04 -0800 (PST) Received: by 10.65.98.13 with HTTP; Wed, 1 Mar 2006 06:28:04 -0800 (PST) Message-ID: Date: Wed, 1 Mar 2006 19:58:04 +0530 From: "AKHILESH GUPTA" To: "AKHILESH GUPTA" , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] regarding grant option In-Reply-To: <20060301134902.GB4800@surnet.cl> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2960_18722110.1141223284234" References: <20060301134902.GB4800@surnet.cl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.396 required=5 tests=[AWL=0.395, HTML_MESSAGE=0.001] X-Spam-Score: 0.396 X-Spam-Level: X-Archive-Number: 200603/12 X-Sequence-Number: 91877 ------=_Part_2960_18722110.1141223284234 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline thank you very much sir for your valuable suggestion, but i am talking about direct database query...........! On 3/1/06, Alvaro Herrera wrote: > > AKHILESH GUPTA wrote: > > > here i have to grant permissions to that user individually for each and > > every table by using: > > :->> grant ALL ON to ; > > GRANT > > and all the permissions are granted to that user for that particular > table. > > Yes. If you are annoyed by having to type too many commands, you can > write a little shell script to do it for you. > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > -- Thanks & Regards, Akhilesh DAV Institute of Management Faridabad(Haryana) GSM:-(+919891606064) (+911744293789) "FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME" ------=_Part_2960_18722110.1141223284234 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline thank you very much sir for your valuable suggestion,
but i am talking a= bout direct database query...........!

On 3/1/06, Alvaro Herrera < alvherre@commandprompt.com> wrote:
AKHILESH GUPTA wrote:

> here i hav= e to grant permissions to that user individually for each and
> every table by using:
> :->> grant ALL ON <tab_name= > to <user_name>;
> GRANT
> and all the permissions ar= e granted to that user for that particular table.

Yes.  If= you are annoyed by having to type too many commands, you can
write a little shell script to do it for you.

--
Alvaro Herre= ra            &= nbsp;           &nbs= p;       http://www.CommandPrompt.com/
PostgreSQL Replication, Con= sulting, Custom Development, 24x7 support



--
Thanks & Regard= s,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:= -(+919891606064)
         &= nbsp;(+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW I= S A CRIME" ------=_Part_2960_18722110.1141223284234--