After an Oracle user has been created and schema objects have been built, best practices dictate that you should not run your applications as the schema owner. Here is a shell procedure and methodology to assist you in maintaining this segregation of application user from database schema owner.

This story continues at http://www.dbasupport.com/oracle/ora...user0201.shtml