Postgres Pro
Downloads
Home   >   mailing lists

Thread: GRANT access on table fields

GRANT access on table fields

From
"Nathalie Boulos"
Date:
Hi,

is there a way to grant or revoke rights on specific fields of a table for
specific users?

if yes how is it possibly done and in which versions of postgres?



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

Re: GRANT access on table fields

From
Karel Zak
Date:
On Fri, Feb 28, 2003 at 12:37:53PM +0200, Nathalie Boulos wrote:
> Hi,
>
> is there a way to grant or revoke rights on specific fields of a table for
> specific users?
>
> if yes how is it possibly done and in which versions of postgres?

 This is not possible in PostgreSQL. It's in TODO, but I think nobody
 works on this very wanted feature :-(

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

Re: GRANT access on table fields

From
"Fouad Fezzi"
Date:
Hi ,

I don't know if you can grant field but i think it's more interesting to
create view and grant users this view.

later please see documentation before request.

Fouad
-----Message d'origine-----
De : pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]De la part de Nathalie Boulos
Envoyé : vendredi 28 février 2003 11:38
À : pgsql-admin@postgresql.org
Objet : [ADMIN] GRANT access on table fields


Hi,

is there a way to grant or revoke rights on specific fields of a table for
specific users?

if yes how is it possibly done and in which versions of postgres?



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: GRANT access on table fields

From
Bruno Wolff III
Date:
On Fri, Feb 28, 2003 at 12:37:53 +0200,
  Nathalie Boulos <nathalieboulos@hotmail.com> wrote:
> Hi,
>
> is there a way to grant or revoke rights on specific fields of a table for
> specific users?
>
> if yes how is it possibly done and in which versions of postgres?

You need to use views or rules to do this. (You could also use functions,
but I don't think this would be a good idea.)