FW: Becoming a user - 10g issue

Oops, I hit reply instead of reply all.  

You're probably running into a password reuse issue, where you can't reuse the last N number of passwords.    

Carol Bristow

DPRA Inc.

1655 N. Ft Myer Dr. Ste925

Arlington, VA 22209

phone: 703-682-2612

fax: 703-528-3100  

From: Carol Bristow
Sent: Wednesday, August 20, 2008 1:35 PM To: 'TESTAJ3_at_nationwide.com'
Subject: RE: Becoming a user - 10g issue  

You're probably running into a password reuse issue, where you can't reuse the last N number of passwords.  

Carol Bristow

DPRA Inc.

1655 N. Ft Myer Dr. Ste925

Arlington, VA 22209

phone: 703-682-2612

fax: 703-528-3100  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com
Sent: Wednesday, August 20, 2008 1:14 PM To: jkstill_at_gmail.com
Cc: cjnewman_at_uillinois.edu; oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
Subject: Re: Becoming a user - 10g issue  

There's a novel concept:

You can't have the password to the application account but you have alter user privilege :)

joe

"Jared Still" <jkstill_at_gmail.com>
  

Sent by: oracle-l-bounce_at_freelists.org

08/20/2008 01:11 PM
Please respond to jkstill_at_gmail.com

From

"Jared Still" <jkstill_at_gmail.com>

To

cjnewman_at_uillinois.edu

cc

oracle-l_at_freelists.org

Subject

Re: Becoming a user - 10g issue      

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.

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


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