March 12, 2009 at 1:38 am
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
March 12, 2009 at 4:43 am
First you connect to that particular database using login 'system'
ie conn system\password@DB_Name as sysdba. Then try
March 13, 2009 at 8:49 am
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.March 13, 2009 at 12:20 pm
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.
March 13, 2009 at 12:31 pm
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
March 16, 2009 at 7:23 am
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
March 17, 2009 at 9:36 am
Gift Peddie (3/13/2009)
... 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.March 17, 2009 at 11:33 am
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
May 4, 2009 at 2:00 pm
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.May 4, 2009 at 2:07 pm
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
May 29, 2009 at 9:12 am
if your DBA haven't change the default password for system then use the default password which is 'manager' (system/manager@dbname) then execure the create user command...
June 1, 2009 at 10:19 am
You are on the right track. Make sure that the account you are logged into has "DBA" role. Then use the create user command. If you have privileges, it will work. If you want to connect to the DB as this user, especially using SQLPlus, you also need to grant the "CREATE SESSION" privilege to the user.
Good Luck!
(Oracle 9i is still alive and well)
June 1, 2009 at 2:31 pm
doug.williams (6/1/2009)(Oracle 9i is still alive and well)
Actually, Oracle 7 is still alive and well 😀
_____________________________________
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.April 1, 2010 at 2:00 am
what is the review for oracle 11i in today's market
April 1, 2010 at 10:31 am
dhaval_dsa (4/1/2010)
what is the review for oracle 11i in today's market
easy money... nobody uses 11i 'cause it doesn't exist 😀
_____________________________________
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.Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply