Re: Impersonate a Oracle User

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 08 Sep 2005 15:25:47 GMT
Message-ID: <%JYTe.2054$7D1.1287@newssvr12.news.prodigy.com>

HansF wrote:

> On Thu, 08 Sep 2005 12:44:27 +0200, Martin shocked us by writing:
>
>

>>Suppose that you are connected to an Oracle database with the user SYS or
>>SYSTEM.
>>
>>I know that there is a way to impersonate another Oracle user account, but I
>>don't remember the command.
>>

>
>
> You may want to rephrase the question and detail what/why you are trying
> to do this. As it stands, the question sounds like you want to do
> something illegal and many [most?] of us will not help.
>

Perhaps the command the OP is looking for is

ALTER SESSION SET CURRENT_SCHEMA = schema

To save time looking it up, here's an excerpt from the doc.

"This setting offers a convenient way to perform operations on objects in a schema other than that of the current user without having to qualify the objects with the schema name. This setting changes the current schema, but it does not change the session user or the current user, nor does it give the session user any additional system or object privileges for the session."

You wouldn't want to be connected as SYS for normal operations in any case, not sure if SYSTEM has an restrictions regarding this statement as I've never tried that case.

-Mark Bole Received on Thu Sep 08 2005 - 10:25:47 CDT