See the documentation for details (http://tahiti.oracle.com)
CREATE USER <user> IDENTIFIED BY <pwd>;
852045 wrote:I'm still confused. Can you post what you are trying and how Oracle responds?
Thanks for replying Oracle version is where i need to create a new user which can access sqlplus /nolog, because i have that with my oradb user but when i create another i cannot access it.
The syntax you provided doent work. I want to create new user and I dont want to work in theWhat do you suppose "Insufficient priveleges" means? You need to be connected to the database as a user who has the CREATE USER system privilege. I seriously doubt that SCOTT has that privilege.
default SCOTT any more. As I am working for my assignments I need to show my name as USER as a proof that
the work is done by me.The syntax below doesnt work. I use oracle 11g SQL PLUS. I am getting error.
CREATE USER name IDENTIFIED BY password;
ERROR at line 1: Insufficient priveleges
Edited by: EdStevens on Jan 3, 2013 7:16 AM
SQL> create user fubar identified by fubar; create user fubar identified by fubar * ERROR at line 1: ORA-01031: insufficient privileges