OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » create user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create user [message #311917]

Mon, 07 April 2008 06:34

ravic.yr@gmail.com
Messages: 3
Registered: April 2008

Junior Member

Hi experts
i want to create a new user can u tell me the comamnd
i trie but insufficient privillages mssg is coming
can u tell me in detail
with regards,
ravi

Report message to a moderator

Re: create user [message #311922 is a reply to message #311917]

Mon, 07 April 2008 06:40

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

What makes you think that this is an expert question? (In case you are still confused, it is NOT an expert question) You are clearly not an expert and therefore should not be posting questions in the expert's forum. The error that you are getting is pretty self explanatory, you do not have the appropriate privileges to perform the task pf creating users. Ask your dba to grant you higher level privileges.

Report message to a moderator

Re: create user [message #312054 is a reply to message #311917]

Mon, 07 April 2008 20:46

bibsdash
Messages: 47
Registered: April 2008

Member

Dear ravic.yr@gmail.com

The Oracle login through( login id which you connect to Oracle) you are trying to create a user doesnot have enough privilege to do so.

If it is Oracle then you can create the user from the following orace seeded logins:

system/manager
sys
any other login having DBA privilege.

[Updated on: Mon, 07 April 2008 20:53]

Report message to a moderator

Re: create user [message #312178 is a reply to message #312054]

Tue, 08 April 2008 02:42

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

bibsdash wrote on Tue, 08 April 2008 02:46

The Oracle login through( login id which you connect to Oracle) you are trying to create a user doesnot have enough privilege to do so.

This has already been said, why repeat it?

Quote:

If it is Oracle

Why would someone post here if it wasn't Oracle?

Quote:

then you can create the user from the following orace seeded logins:
system/manager
sys
any other login having DBA privilege.

Incomplete. What about the following example?

SQL> sho user
USER is "HR"
SQL> SELECT * FROM SESSION_ROLES;

ROLE
------------------------------
RESOURCE

SQL> CREATE USER foo IDENTIFIED BY bar;

User created.

SQL> DROP USER foo;

User dropped.

Quite clearly, the user HR does NOT have the DBA role and yet they can create and drop users. It is great that you are posting to help people out, but you need to be more accurate with your answers (and try not to repeat what has already been said by other posters - unless the OP doesn't seem to be getting the point Wink

)

Report message to a moderator

Re: create user [message #312326 is a reply to message #312178]

Tue, 08 April 2008 10:15

bibsdash
Messages: 47
Registered: April 2008

Member

pablolee

The HR user is most of the times dropped from Oracle production systems.We donot have.Generally SYS and SYSTEM users exist on most of the Oracle systems.

Thanks for the info.

Report message to a moderator

Re: create user [message #312330 is a reply to message #312326]

Tue, 08 April 2008 10:35

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

bibsdash wrote on Tue, 08 April 2008 16:15

pablolee

The HR user is most of the times dropped from Oracle production systems.

So, I simply used HR as an example. The point was that a user does not need to have the DBA privilege in order to create(or drop) a user as your post implies.

Quote:

Generally SYS and SYSTEM users exist on most of the Oracle systems.

Replace most with ALL. This is still irrelevant - see the clarification of the point that I was making. In fact, to suggest that sys should be used for a task like creating users is foolish. Creating users is a fairly low level task (in the scheme of administration tasks), the sys user should be reserved for ONLY high level tasks such as Shutting down/ starting up/ backing up the database etc certainly NOT for creating users.

Report message to a moderator

Re: create user [message #312333 is a reply to message #312330]

Tue, 08 April 2008 10:38

bibsdash
Messages: 47
Registered: April 2008

Member

pablolee
I agree with you.

Report message to a moderator

Previous Topic:	Convert Short Date to Date
Next Topic:	how to fetch first record of each group

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 15:51:36 CST 2024