DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: database users

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    database users

    Dear all,

    When I created a database use dbca, I found these users were created:
    MDDATA, TSMSYS, DIP, DBSNMP, WMSYS, ORDSYS, EXFSYS, XDB, DMSYS, OLAPSYS, MDSYS, SYSMAN, CTXSYS, OUTLN

    Now, I am trying to create an Oracle 10g database manually. I would like to find out what script(s) I should execute in order to create these users with appropriate roles assigned? Any help is appreciated!


    Thanks,
    Unna

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well first work out what you need and then create the ones you want, look up that word in the docs and it will tell you how to create it

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Check this Metalink, gives you details of all the schema and thier use and why you need them?

  4. #4
    Join Date
    Feb 2003
    Posts
    63

    Do you really need them?

    Best if you don't them not to create them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width