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

Thread: creating user

  1. #1
    Join Date
    Jan 2003
    Posts
    33

    creating user

    Hello,
    after loging on as sys (I also tried with system)
    and trying to create a new user with the same configuration as the user sys using the "create like..." function of the "Entrprise Manager Console" of 9i,

    I get the error ORA 990 Missing or invalid privileg

    anyone knows which privilegs are meant? I also dont know if they are missing or invalid :(

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    Try assigning OEM_Monitor priv.

  3. #3
    Join Date
    Jan 2003
    Posts
    33
    I had already the
    OEM_Monitor priviledge set.
    I tried not to grat this priviledge, without any success...

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Just to clarify, are you trying to create a duplicate SYS user?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Jan 2003
    Posts
    33
    Yes that´s the idea

    and using the "create like..." function of the "Entrprise Manager Console" of 9i you get a mask where you only have to insert the user name and its password. The configuration of the new user is (I didn't look privileg after privileg to check) the same as for sys

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Why do you need a duplicate of the SYS user? IMHO a better approach would be to create an administrator account and grant only required privileges to that account.

    If you create users with excessive privileges you will end up with a security nightmare.

    If SYS privileges are required to perform a task, use the SYS user.

    Of course there may be a particular reason you are attempting to do this.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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