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
