Re: changing pswds of standard accounts

On Aug 4, 6:05 am, DA Morgan <damor..._at_psoug.org> wrote:
> 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.

Strange that DBSNMP didn't spring up in a mind of such OEM fundamentalist :)

> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Mon Aug 06 2007 - 18:44:13 CDT