Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How to create user in Oracle 9i Expand / Collapse
Author
Message
Posted Thursday, March 12, 2009 1:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 5, 2011 2:42 AM
Points: 17, Visits: 90
Hi
I am new in Oracle,but i work mainly on sql server 2000 & 2005.I just install the oracle 9i in my system.I want to make an user.so i open the Oracle SQL*plus.and enter in it using the login name as scott and paswword as tiger.
When i used the command "create user vivek identified by vivek;" it shows the following error.
SQL> create user vivek identified by vivek;
create user vivek identified by vivek
*
ERROR at line 1:
ORA-01031: insufficient privileges

please tell me how can i create user in it.

Vivek



Nothing Is Impossible
Post #673975
Posted Thursday, March 12, 2009 4:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:34 AM
Points: 2,609, Visits: 3,903
First you connect to that particular database using login 'system'
ie conn system\password@DB_Name as sysdba. Then try
Post #674058
Posted Friday, March 13, 2009 8:49 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
Ratheesh.K.Nair (3/12/2009)
First you connect to that particular database using login 'system'
ie conn system\password@DB_Name as sysdba. Then try
BA

SYS and SYSTEM are Oracle equivalents of "sa" account; you don't want to connect to the database using such powerfull accounts just to create an user.

Ask your Oracle DBA to grant you the privileges or, if you are the DBA just use your DBA account -the one who belongs to the DBA ROLE.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #675253
Posted Friday, March 13, 2009 12:20 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:01 PM
Points: 417, Visits: 1,149
The user scott should only be used testing purposes only. Scott has limited priveleges in the database and can not create new users. I agree with the previous posters. If you are the DBA log in with the sys or system acocunt and create a user with appropriate priveleges to perform the functions you need. Also if this is a production environment, delete or disable the scott account as it poses a security issue.
Post #675498
Posted Friday, March 13, 2009 12:31 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:22 AM
Points: 3,428, Visits: 14,430
The user scott should only be used testing purposes only. Scott has limited priveleges in the database and can not create new users.


I wanted to add that when the thread was without replies but my actual question would be what are you doing with Oracle 9i because most people are now running 10g and 11g both comes without Scott. The Scott account was cancelled in Oracle 10g.

:)


Kind regards,
Gift Peddie
Post #675508
Posted Monday, March 16, 2009 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 5, 2009 2:06 AM
Points: 1, Visits: 17
Hi,

You should specify default temporary tablespace for new user.

You can replicate user from one Oracle database to other Oracle database by specifying encoded password.

BR,
Ivan Surovezhin
Post #676458
Posted Tuesday, March 17, 2009 9:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
Gift Peddie (3/13/2009)
[quote]... my actual question would be what are you doing with Oracle 9i because most people are now running 10g and 11g


This statement does not reflects reality.

Ora9i + Ora8i are still the most used versions of Oracle.

Ora10g is slowly getting in the Corporate world not to mention they may be just a few Ora11g corporate production environments out there.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #677615
Posted Tuesday, March 17, 2009 11:33 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:22 AM
Points: 3,428, Visits: 14,430
In the US I have not seen 8i or 9i for development since 2006, you may be talking about admin I am talking about development. The reason you cannot use 8i for multi lingual application and you need MSDTC to use 9i for layered .NET transaction application.



Kind regards,
Gift Peddie
Post #677731
Posted Monday, May 4, 2009 2:00 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
Gift Peddie (3/17/2009)
In the US I have not seen 8i or 9i for development since 2006, you may be talking about admin I am talking about development. The reason you cannot use 8i for multi lingual application and you need MSDTC to use 9i for layered .NET transaction application.



Small shop, huh?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #709687
Posted Monday, May 4, 2009 2:07 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:22 AM
Points: 3,428, Visits: 14,430
PaulB (5/4/2009)
Gift Peddie (3/17/2009)
In the US I have not seen 8i or 9i for development since 2006, you may be talking about admin I am talking about development. The reason you cannot use 8i for multi lingual application and you need MSDTC to use 9i for layered .NET transaction application.



Small shop, huh?


I am not sure a small shop can develop an Asp.net application running in 18 states in the US.







Kind regards,
Gift Peddie
Post #709697
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse