Re: changing pswds of standard accounts

On Fri, 03 Aug 2007 08:24:10 -0700, EdStevens <quetico_man_at_yahoo.com> 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.

http://www.petefinnigan.com or
http://otn.oracle.com 'Project Lockdown' by Arup Nanda. According to him tne dbsnmp password is not in procedures, don't knwo where you got that fairy tale from.

-- 
Sybrand Bakker
Senior Oracle DBA