Pluto <pluto@annoyance.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.