Re: Becoming a user - 10g issue

Clever solution.

On Thu, Aug 21, 2008 at 1:54 PM, Yong Huang <yong321_at_yahoo.com> wrote:

> What I usually do to create a private DB link or stop or start another
> user's
> DBMS job, is to create a temporary procedure in that schema:
>
> conn system
> create or replace procedure yhuang.p as
> begin
> execute immediate 'create database link remotedb
> connect to remoteuser identified by thepassword using ''remotedb''';
> end;
> /
> exec yhuang.p
> drop procedure yhuang.p;
>
> The advantage is you don't change that user's password even for a
> subsecond. So
> there's no risk in that respect.
>
> I wish Oracle would support "create database link theuser.linkname...", or
> give
> us a general method as Windows's "Run as" functionality.
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l