view and column rights - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject view and column rights
Date
Msg-id 20100627163615.1a285029@anubis.defcon1
Whole thread Raw
Responses Re: view and column rights  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi list,

If I give column rights to a user, I can't use a general view for him, which
is normal.
I read a lot about DBs and some specialists say that I must not give
direct data (table) access to users but always through a view.

Are they right? (meaning I must have as much views as users - and how
can I do that, where to put them, shall I generate them on-ze-fly,...?),

or are they wrong (meaning I only have to recover user's rights at
connection and build my queries accordingly directly toward tables)?

Whatever the complexity, security is the master word here.

JY
--
A sine curve goes off to infinity, or at least the end of the blackboard.
        -- Prof. Steiner

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: escape
Next
From: Tom Lane
Date:
Subject: Re: escape