Re: Becoming a user - 10g issue

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:

http://asktoad.com/DWiki/doku.php/howto_create_dblinks_database_links_in_another_schema

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 <cjnewman_at_uillinois.edu
>> 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.

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