Re: Data access permission?

Thanks to all who reply to my question, you do really help!

Pluto

Oliver Elphick wrote:

> Pluto wrote:
> >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!
>
> What you need to do is to deny access to the underlying table, but
> create views containing each user's particular data and make those views
> readable by the appropriate users. Updatable views are not yet
> implemented, so you will have to do some roundabout work to enable
> users to update data - perhaps have them store data in intermediate locations
> from which some other process transfers the data into the underlying table.
>
> You probably need to be running 7.1 to do this effectively.
>
> --
> Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight http://www.lfix.co.uk/oliver
> PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
> ========================================
> "But the fruit of the Spirit is love, joy, peace,
> patience, kindness, goodness, faithfulness,
> gentleness, self control; against such there is no
> law." Galatians 5:22,23
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html