I don't think you can connect as another user within a procedure (unless you do so via a database link).

Regards