create user

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

5 Days

Discussion Span

9 Months Ago

Last Updated

6

Views

pooja28

Newbie Poster

4 posts since Feb 2011

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

9 Months Ago

0

insufficient priviveleges on password

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

pritaeas

Posting Prodigy

Moderator

9,315 posts since Jul 2006

Reputation Points: 1,178

Solved Threads: 1,465

Skill Endorsements: 86

9 Months Ago

0

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.

pooja28

Newbie Poster

4 posts since Feb 2011

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

9 Months Ago

0

try this

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

debasisdas

Posting Genius

6,968 posts since Feb 2007

Reputation Points: 722

Solved Threads: 457

Skill Endorsements: 20

9 Months Ago

0

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

pooja28jan

Newbie Poster

1 post since Aug 2012

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

9 Months Ago

0

Pls check the line 4, you will find some difference.

debasisdas

Posting Genius

6,968 posts since Feb 2007

Reputation Points: 722

Solved Threads: 457

Skill Endorsements: 20

create user

This article has been dead for over three months: Start a new discussion instead