>Personally I prefer connecting as the DB owner within the app as Kelly talked about and NOT using SPs only. I do not have to prefix tables with the schema name, I do not have to deal with privs on the DB side. You can get as creative as you want with how you set up who can do what. I do this with a user access table in Oracle.

How does this work if you are the db owner of more than one of the schemas?

I like this approach.

Problem is that this is generic code in a bus object layer. I think making assumptions like this are a bad call. As I mentioned to Kelly I think the only real workaround for this is to use a Database prefix as an optional property on the bus object.

+++ Rick ---