Connect Through PLSQL with different user question

Hi all,

Is it possible in PLSQL through stored procedures to connect to the database with different user. I’ve tried this EXECUTE IMMEDIATE 'Connect john/test' ;
But it did not work
All I want to do is when user X ( he owns the procedure ) calles the stored procedure , that stored procedure try to connect user Y to the database that is all .

So is it possible to achieve this task through PLSQL and if Yes please show me how.

Thanks in advance

Khaled

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 21 2000 - 18:13:16 CST