Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: changing pswds of standard accounts

Re: changing pswds of standard accounts

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 03 Aug 2007 13:05:10 -0700
Message-ID: <1186171508.498556@bubbleator.drizzle.com>


EdStevens wrote:
> Platform: Ora EE 10.2.0.2.0 on HP-UX
>
> We have a directive to change *all* passwords every 150 days, so I am
> looking at all of the Oracle 'standard' accounts. I know there are
> special considerations for DBSNMP and SYSMAN. Looking at MetaLink
> note 160861.1 and some of the links from there, I'm getting a mixed
> bag of suggestions on the others -- usually either a simple change
> with no real effect, to vague descriptions of what the account is for
> and no mention of considerations for password changes.
>
> Here are the accounts in question, that exist on our system:
>
> MGMT_VIEW
>
> MDSYS (oddly, MDDATA and CTXSYS, which seem to be associated, do not
> exist)
> ORDSYS
> ORDPLUGINS
> SI_INFORMTN_SCHEMA
> WMSYS
> ANONYMOUS
> XDB
> EXFSYS
> DIP
> TSMSYS
>
> I'm not even sure the features associated with some of these are even
> being used, but my question here is do any of these pose problems with
> changing the passwords (like exist for DBSMNP - password is baked into
> some other files or procedures) or can they simply be changed like any
> other user account?
>
> Thanks.

I am not aware of a single Oracle password that can not be changed at will provided you haven't hard coded it into shell scripts and the like. And if you have fix the scripts.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Aug 03 2007 - 15:05:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US