>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 ---