hi to all,
i want to create user on student table IN ORACLE....
CREATE USER john IDENTIFIED BY out_standing
DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users
DEFAULT TABLESPACE temp
QUOTA UNLIMITED ON system;
but, oracle shows following error like...."insufficient priviveleges on password...
please give some suggestion for creating user in above code....
Thanks.
Jump to Postinsufficient priviveleges on password
Make sure you are logged in with a user that is allowed to create a user.
Jump to Posttry this
CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON system;
insufficient priviveleges on password
Make sure you are logged in with a user that is allowed to create a user.
pritaeas,
I am at very first stage of oracle,
I don't think so, that someone on 'sql plus' restrict to create user....i think may be the syntax is wrong or some problem with password field.
try this
CREATE USER john IDENTIFIED BY out_standing
DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON system;
debasisdas,
thanks for reply, but your suggestion is jusk like my query.
Pls check the line 4, you will find some difference.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.