Home » SQL & PL/SQL » SQL & PL/SQL » create user
create user [message #311917] Mon, 07 April 2008 06:34 Go to next message
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
Re: create user [message #311922 is a reply to message #311917] Mon, 07 April 2008 06:40 Go to previous messageGo to next message
pablolee
Messages: 2835
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.
Re: create user [message #312054 is a reply to message #311917] Mon, 07 April 2008 20:46 Go to previous messageGo to next message
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 Go to previous messageGo to next message
pablolee
Messages: 2835
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 )
Re: create user [message #312326 is a reply to message #312178] Tue, 08 April 2008 10:15 Go to previous messageGo to next message
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.
Re: create user [message #312330 is a reply to message #312326] Tue, 08 April 2008 10:35 Go to previous messageGo to next message
pablolee
Messages: 2835
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.
Re: create user [message #312333 is a reply to message #312330] Tue, 08 April 2008 10:38 Go to previous message
bibsdash
Messages: 47
Registered: April 2008
Member
pablolee
I agree with you.
Previous Topic: Convert Short Date to Date
Next Topic: how to fetch first record of each group
Goto Forum:
  


Current Time: Thu Dec 08 14:26:47 CST 2016

Total time taken to generate the page: 0.05100 seconds