Thanks for all your replies. Both your strategies - SP_CHANGEOBJECTOWNER and execution with login as 'w_provision' will serve the purpose, but I still am wondering why is the user who...

Thanks Racosta. That did work, but I need to be able to access the table as

OSS.table_name. All the front end queries are already formatted that way.

Shiva.