Re: Data access permission?

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Pluto <pluto(at)annoyance(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data access permission?
Date: 2001-03-30 18:21:23
Message-ID: m3d7azkti4.fsf@dep1.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pluto <pluto(at)annoyance(dot)net> writes:

> Dear all
>
> Can PostgreSQL, MySQL or other database programs can allow some user to
> access some specific data while other data is prohibited to them in a
> same database? If so, how to implement that? For instance, a client can
> print last month's statement through the Internet by providing a
> password to him/her; this client can only check the data that belong to
> him/her, at the meantime, there is other clients' data in the same
> database. Thanks for your kind help!

I don't understand very well the idea. If you want to restrict user
access per table you can do it using the commands grant/revoke;
however if you want to restrict user access per row; I'm afraid this
is not possible, at least not without triggers or rules.

Regards,
Manuel.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ADBAAMD 2001-03-30 18:29:56 Re: What is faster?
Previous Message Soma Interesting 2001-03-30 18:06:50 RE: dynamic field names in a function.