Re: The "BECOME USER" system privilege

From: Martin Haltmayer <Martin_Haltmayer_at_in.augsburg.net>
Date: Tue, 20 Apr 1999 23:37:30 +0200
Message-ID: <7fo19d$809$1@cache.augsburg.net>

Try

alter session set current_schema = 'WHATEVERSCHEMAYOUWANT';

Martin

Johan Wegener <120010082756_at_post.tele.dk> schrieb in Nachricht <7fih8g$n45$1_at_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
>
>
Received on Tue Apr 20 1999 - 16:37:30 CDT