Member Avatar for pooja28

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.

  • 4 Contributors
  • 5 Replies
  • 196 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for pritaeas

insufficient priviveleges on password

Make sure you are logged in with a user that is allowed to create a user.

Member Avatar for pooja28

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.

Member Avatar for debasisdas

try this

CREATE USER john IDENTIFIED BY out_standing
DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON system;
Member Avatar for pooja28jan

debasisdas,
thanks for reply, but your suggestion is jusk like my query.

Member Avatar for debasisdas

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.