0

Are there side effects of changing the profile of sys to any other than default?

Our monitoring keeps telling us the password of sys has expired. The "Default“ profile has a standard limit of 180 days. Even this does not apply – the password of sys is marked as expired.

0
2

Our monitoring keeps telling us the password of sys has expired. The "Default“ profile has a standard limit of 180 days.

You should not try to change the Profile for internal, Oracle accounts (indeed, there is one, very oddly named, account that you cannot changed in any way, shape or form!).

You should not change the behaviour of the DEFAULT profile.
The "default" behaviours can change from version to version of Oracle Database and so may be unexpectedly "reset" on you, during an upgrade.

If you want to tie down these behaviours, define your own Profiles and configure them as you need them.

CREATE PROFILE APPLICATION_ACCOUNTS 
    LIMIT 
    PASSWORD_LIFETIME UNLIMITED 
    ; 
ALTER USER APP_1_ACCOUNT PROFILE APPLICATION_ACCOUNTS ; 
ALTER USER APP_2_ACCOUNT PROFILE APPLICATION_ACCOUNTS ; 

CREATE PROFILE INTERACTIVE_USER 
    LIMIT 
    PASSWORD_LIFETIME 180 
    . . . 
    ; 
ALTER USER FRED   PROFILE INTERACTIVE_USER ; 
ALTER USER BARNEY PROFILE INTERACTIVE_USER ; 

Anything you don't specify in your custom profiles will, of course, be "inherited" from the DEFAULT one.

0

Solution maybe to change the PASSWORD_LIFE_TIME of DEFAULT profile.

Oracle docs:

PASSWORD_LIFE_TIME Of DEFAULT Profile Changed From Unlimited To 180 (Doc ID 2437775.1).

However it is a wanted behavior all passwords in Default Profile expire after 180 days.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.