Re: Separation of clients' data within a database

["Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>]

>>> On Thu, Nov 30, 2006 at 12:48 PM, in message
<456F2795(dot)3070603(at)hardgeus(dot)com>,
John McCawley <nospam(at)hardgeus(dot)com> 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