Xref: alice comp.databases.oracle.server:46713
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!news.maxwell.syr.edu!newsfeed.ecrc.net!fu-berlin.de!news.augsburg.net!not-for-mail
From: "Martin Haltmayer" <Martin_Haltmayer@in.augsburg.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: The "BECOME USER" system privilege
Date: Tue, 20 Apr 1999 23:37:30 +0200
Lines: 29
Message-ID: <7fo19d$809$1@cache.augsburg.net>
References: <7fih8g$n45$1@news.inet.tele.dk>
X-Trace: cache.augsburg.net 924813421 8201 195.222.96.121 (22 Apr 1999 20:37:01 GMT)
X-Complaints-To: usenet@news.augsburg.net
NNTP-Posting-Date: 22 Apr 1999 20:37:01 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Try

alter session set current_schema = 'WHATEVERSCHEMAYOUWANT';

Martin

Johan Wegener <120010082756@post.tele.dk> schrieb in Nachricht
<7fih8g$n45$1@news.inet.tele.dk>...
>Hello,
>
>I am interested in learning something about the BECOME USER system
>privilege: Do I understand it correctly when I assume that a user with this
>privilege can log in as another user without knowing the password of this
>user?
>
>If it is so, how do I actually do this? I have studied the documentation
and
>the data dictionary extensively, but it appears almost undocumented.. I can
>find no description of it other than it is granted to the
>"IMP_FULL_DATABASE" role.
>
>I would appreciate any comment on this, thanks in advance.
>
>Cheers,
>Johan
>
>