>>> On Thu, Nov 30, 2006 at 12:48 PM, in message <456F2795.3070603@xxxxxxxxxxxx>, John McCawley <nospam@xxxxxxxxxxxx> 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
