Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group