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 |
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 |