RE: Data access permission?

If he wants to restrict access to certains rows, he could create views on
those tables containing only the desired rows and then grant access in that
view to the correspondent user. Of course, he would have to create a view to
each user, but that would be no worse than manually grant/revoke access to
rows (if that were possible).

Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informação
E-mail: carlosz(at)dbserver(dot)com(dot)br
Fone: (51) 342-8055 / (51) 378-9056
Fax: (51) 342-4838

-----Original Message-----
From: Manuel Sugawara [mailto:masm(at)fciencias(dot)unam(dot)mx]
Sent: sexta-feira, 30 de março de 2001 15:21
To: Pluto
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Data access permission?

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.

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

http://www.postgresql.org/search.mpl