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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.