password change

Posted on 2011-04-20
Last Modified: 2012-05-11

Can i change the passwords of sys and system when the database is up. will any anyone running jobs as sys or system be affected by this?

Question by:aravind_314
    LVL 73

    Accepted Solution

    can you?  yes
    will it affect jobs already running?  no

    the password change will only affect the NEXT session that tries to log in,  not anything that is already connected
    LVL 73

    Assisted Solution

    do note though,  nobody should actually be running anything as SYS unless there is an installation, upgrade or grant to sys owned object.

    Unfortunately it's a common practice for people to do lots of things as SYS when they don't need to.
    SYSTEM is also overpowered for most activities, but is at least a step away from using SYS all the time.

    SYS is a special user,  permissions, auditting, policies etc don't behave the same for SYS as for other users.
    So, not only is powerful enough to do a lot of damage, but it also doesn't "play by the rules" so its use isn't recommended
    for anything except those actions where it actually required, which is rare.
    LVL 23

    Assisted Solution

    hi aravind,
    - do you have DB Console installed? if you change the SYS and SYSTEM password in SQL Plus, then it also must be changed in DB Console too. changing it in DB Console would require you to login as SYSMAN user and then go to setup (top right corner) click on Administrators and change it there.
    LVL 2

    Expert Comment

    yes You can change your sys and system what ever  jobs are running. tey affect on next session ...u not need worry about the current session..
    LVL 73

    Expert Comment

    spyresonse,  that's the same thing said above.  please read all previous posts to be sure you're not posting duplicate information

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now