Re: row level grants - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: row level grants
Date
Msg-id 40E486A2.50502@commandprompt.com
Whole thread Raw
In response to row level grants  (Alexander Cohen <alex@toomuchspace.com>)
List 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@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-general by date:

Previous
From: isidore assi
Date:
Subject: demande d'aide
Next
From: Tom Lane
Date:
Subject: Re: postgresql +AMD64 +big address spaces - does it work?