Ora-01031 Insufficient privileges - SYSTEM USER Oracle 11g
Getting error ora-01031 - Insufficient privileges when creating a new user as SYS or SYSTEM.
Checked dba_user_roles and SYS and SYSTEM user have DBA privileges granted.
Is there a new feature in Oracle 11g that require an explicit privilege granted to SYS or SYSTEM to enable create user command?
Thanks.
Checked dba_user_roles and SYS and SYSTEM user have DBA privileges granted.
Is there a new feature in Oracle 11g that require an explicit privilege granted to SYS or SYSTEM to enable create user command?
Thanks.
ASKER
Hi,
I tried both OEM, command line as well as using TOAD. Same error message.
I think problem could be something to do with privileges for SYS or SYSTEM schema. Since it is a new database with hardly any data inside, I will drop entire database and create a fresh one :-).
I will wait few more hours to see if I can get any suggestions from someone else that might help in resolving this error.
I tried both OEM, command line as well as using TOAD. Same error message.
I think problem could be something to do with privileges for SYS or SYSTEM schema. Since it is a new database with hardly any data inside, I will drop entire database and create a fresh one :-).
I will wait few more hours to see if I can get any suggestions from someone else that might help in resolving this error.
Not connecting as NORMAL, are you?
ASKER
No.
Hate to erase problem with a quick and easy fix. I dropped and recreated my database since it was local on my laptop. Now I can create a user with SYSTEM and SYS. Hate to throw away a problem without a proper solution.
I will investigate again if occurs again, reopen thread and post solution if found.
Thanks.
Hate to erase problem with a quick and easy fix. I dropped and recreated my database since it was local on my laptop. Now I can create a user with SYSTEM and SYS. Hate to throw away a problem without a proper solution.
I will investigate again if occurs again, reopen thread and post solution if found.
Thanks.
ASKER
Leaving thread open for couple of days.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not aware of any changes in 11g for this. Are you doing this from the command line or from OEM? If you are going through OEM, I'd try it again from command line and connect / as sysdba to ensure that you're logging in as sys.
Good luck!