March 12, 2009 at 2:12 am
Hi
I am new in Oracle,but i work mainly on sql server 2000 & 2005.I just install the oracle 9i in my system.I want to make an user.so i open the Oracle SQL*plus.and enter in it using the login name as scott and paswword as tiger.
When i used the command "create user vivek identified by vivek;" it shows the following error.
SQL> create user vivek identified by vivek;
create user vivek identified by vivek
*
ERROR at line 1:
ORA-01031: insufficient privileges
please tell me how can i create user in it.
Vivek
Nothing Is Impossible
March 19, 2009 at 2:16 am
The user Scott is a demo user with low privileges. You need to log in as system or sys to create a new user.
March 20, 2009 at 8:18 am
As mentioned, you need to log into SQLPlus with an account that has enough privs to create another account ... sys, system or an account with DBA privs.
You should also give the user a default tablespace and default temporary tablespace.... nothing any worse that creating user objects in Oracle's system tablespace ...
sql> create user username identified by password default tablespace yourtablespacename temporary tablespace yourtemptablespacename;
sql> grant connect to newusername;
You may need to grant other privs to your new user
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply