Re: Becoming a user - 10g issue

From: Rich Jesse <>
Date: Wed, 20 Aug 2008 12:36:10 -0500 (CDT)
Message-ID: <47926.>

I've needed to do this in order to create private database links for a particular schema. And as luck would have it, I documented the procedure for public viewing:

As SYSDBA, these actions aren't normally in the Oracle audit trail, but that's another thread... :)

HTH! GL! Rich

> On Wed, Aug 20, 2008 at 9:56 AM, Newman, Christopher <
>> wrote:
>> select 'alter user &1 identified by values
>> '||chr(39)||password||chr(39)||' replace temp;' ?
> What does your security department and/or auditors say about doing this?
> You don't say what kind of accounts you are logging onto, but if I had
> to guess I would guess that they are application accounts.
> Wouldn't be better to use the password of the account?
> And if you are not allowed to have the password, I guess you're
> not allowed to make changes.

Received on Wed Aug 20 2008 - 12:36:10 CDT

Original text of this message