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@xxxxxxxxxxxxx >> 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. -- //www.freelists.org/webpage/oracle-l