Re: row level grants

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Alexander Cohen <alex(at)toomuchspace(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row level grants
Date: 2004-07-01 21:48:18
Message-ID: 40E486A2.50502@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Cohen wrote:
> Is there any way to grant user access at the row level? Or maybe some
> way to simulate it?

If you can write a query to will return only the rows you want the user
to see, you can write a view that returns those rows and grant rights to
that view.

J

>
> Alex
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-07-01 22:31:13 Re: postgresql +AMD64 +big address spaces - does it work?
Previous Message Joe Conway 2004-07-01 21:47:32 Re: row level grants