-
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 :(
-
Try assigning OEM_Monitor priv.
-
I had already the
OEM_Monitor priviledge set.
I tried not to grat this priviledge, without any success...
-
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!
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|