Predefined Administrative Accounts in Oracle 11gR2

Posted on 2011-05-02
Last Modified: 2012-05-11
At my company, we run a query/report to determining which accounts are expired or will be expiring.  There are two predefined Admin accounts I was curious about.  They're called MGMT_VIEW and XS$NULL.  I don't think we use these accounts for anything, I think they're just there when we setup a new instance of oracle on one of our production Linux servers.  My question is, should we keep them up and running and make sure their passwords get changed routinely and don't get locked out or can they just be expired and locked (incase we need them later for something).  Any help or info on this matter would be much appreciated.


Question by:WCH_Applications
    1 Comment
    LVL 23

    Accepted Solution

    - both id is used by oracle. MGMT_VIEW used by Oracle Enterprise Manager Database Control and XS$NULL can only be accessed by the Oracle Database instance. therefore you need to keep both running.

    read further here:

    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

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    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 take different types of Oracle backups using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    734 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

    19 Experts available now in Live!

    Get 1:1 Help Now