Re: Connect Through PLSQL with different user question

From: <mkrolewski_at_rosetta.org>
Date: Wed, 22 Nov 2000 00:36:58 GMT
Message-ID: <8vf4f9$h9g$1@nnrp1.deja.com>

In article <8vf32m$g95$1_at_nnrp1.deja.com>, kachkar_at_my-deja.com wrote:
> 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.
>

Your question appears to be mechanism to circumvent the entire security scheme. Why does a specific user need to be logged in as another? Generally, roles and grants can accomplish any authorized transfer of privilege.

Michael Krolewski

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