DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=OXfLW8xLx0bOo7ScUaCQPVfv+27tjwtcw1/mqZ0Nl9xh/CzGg+t0cD7hn826UFJX6Z
	kOB6l0GpEQCEv/uQ43BOPCX59L1hk4kwMxP+kcSnu0xXMMjQMl537yf01I4tRt0utPJl
	4C1ZA7O/ekUOpmfny9HS605mlQ5xayi/8VfMQ=
Message-ID: <2352385b0806190018q4231ba53t317531dacbf31fb3@mail.gmail.com>
Date: Thu, 19 Jun 2008 00:18:01 -0700
From: "pradeep kumar" <pradeep4uiiita@gmail.com>
To: depesz@depesz.com
Subject: Re: URGENT: how to GRANT privillages to user/role on relation's row??
Cc: pgsql-admin@postgresql.org
In-Reply-To: <20080618171118.GA22791@depesz.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <2352385b0806181005k4b96695cs3e954afab69350b@mail.gmail.com>
	<20080618171118.GA22791@depesz.com>

how to GRANT privillages to user/role on relation's row??

we can grant privvilages to user/role on tables/relations by
GRANT options[SELECT | INSERT | UPDATE | DELETE | REFERENCES | TRIGGER
|ALL]privillages ON relation/tablename TO dbuser/role;
GRANT command but how can we GRANT privillages to a user on a row ??? ?


is it possible by RULES ????

On 6/18/08, hubert depesz lubaczewski <depesz@depesz.com> wrote:
> On Wed, Jun 18, 2008 at 10:05:13AM -0700, pradeep kumar wrote:
>> GRANT command but how can we GRANT privillages to a user on a row ??? ?
>
> in standard postgresql you can't.
>
> if you want row-level privileges, check this:
> http://code.google.com/p/sepgsql/
>
> depesz
>