>>> On Thu, Nov 30, 2006 at 12:48 PM, in message
<[EMAIL PROTECTED]>,
John McCawley <[EMAIL PROTECTED]> wrote:
>
> 4) Create views for each client that filter the underlying table data
to
> only show them their data. The only database objects they would have
> read permission on are these views. Come to think of it, this is
> probably the best way to go.
That's what I'd be looking at. Be sure to revoke public rights on the
database and public schema, and grant back the rights you want. Think
about using the schemas to segregate the views for the various clients.
-Kevin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
