How to create user in Oracle?

Login or Register to Ask a Question and Join Our Community

How to create user in Oracle?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to create user in Oracle?

10-06-2010

Registered User

120, 2

Join Date: Apr 2010

Last Activity: 29 October 2010, 4:38 AM EDT

Posts: 120

Thanks Given: 2

Thanked 2 Times in 2 Posts

How to create user in Oracle?

Hello,

could any one tell me that, How to create new user in oracle?
I know the command,

Code:

 
 create user <username> identified by <password>

But if I give this command on /Home$ prompt, I am getting error as,

Code:

create : not found.

Please let me know if anyhting is wrong in my command? also let me know the correct way to do it.
I am having AIX OS and Oracle database. In my database there is one user called ora, Now I want to create another user using logins of ora user.
Thanks in advance.

Last edited by Poonamol; 10-06-2010 at 02:04 AM.. Reason: error is inserted

Poonamol

View Public Profile for Poonamol

Find all posts by Poonamol

10-06-2010

Registered User

1,690, 205

Join Date: Jun 2007

Last Activity: 13 July 2020, 5:35 PM EDT

Location: Mumbai, India

Posts: 1,690

Thanks Given: 139

Thanked 205 Times in 199 Posts

If you want to create user in oracle, you must first connect to database.
running oracle commands on unix prompt would result syntax errors/command not found etc.

If you are a professional, I would suggest to sit with seniors/Dba and have some basic knowledge of unix and oracle. Google could also helpful for you.

coming back to your problem,
you need to have sql prompt on your terminal ( the method is same as described in your other posts as a solution) or use any GUI tools ( eg toad, pl/sql developer etc )

clx

View Public Profile for clx

Find all posts by clx

10-06-2010

Registered User

120, 2

Join Date: Apr 2010

Last Activity: 29 October 2010, 4:38 AM EDT

Posts: 120

Thanks Given: 2

Thanked 2 Times in 2 Posts

Thanks for your time and help.
I think I am not having that much access previleges on DB server, so, I'll try to do it with help of seniors/DBA.

Poonamol

View Public Profile for Poonamol

Find all posts by Poonamol

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find if a User exist if not create user

What I'm trying to do is write a script in Perl to find a user and if that user exist it would print "User Exist, Pls Try Again". If The user doesn't exist I'm able to create a user with a password. Any suggestions?

2. UNIX and Linux Applications

Really simple shell script to create oracle database

Hello , I am new in this forum and need your help as I am totally confused :confused: I read a lot of threads and tried to search a lot but did not get the exact answer to my question. I just want a simple (content wise may be long) shell script to create oracle database. In detail:...

3. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;...

4. Homework & Coursework Questions

Create script to add user and create directory

first off let me introduce myself. My name is Eric and I am new to linux, I am taking an advanced linux administration class and we are tasked with creating a script to add new users that anyone can run, has to check for the existence of a directory. if the directory does not exist then it has...

5. Ubuntu

Create New User with the same group nd privileges of the other user

Hi, Anyone can help me on how to duplicate privileges and group for useroradb01 to userrootdb01. I have currently using "useroradb01" and create a newly user "userrootdb01". I want both in the sames privileges and group. Please see the existing users list below; drwxr-xr-x 53 useroradb01...

6. Shell Programming and Scripting

[ORACLE] CREATE TABLE in bash

Hey, I want to create a table in bash, my db server is oracle. You can find my script below: I am very confused. I tried to run this script many times without any luck. Please help!

7. HP-UX

to create a oracle table in perl script

Hi all, I have to create table for each month inside a perl script. tablename_monthnameyear. megh_aug2008 for august 2008. megh_sep2008 for september 2008. just like the logfiles created on date basis. thanks megh

8. UNIX for Dummies Questions & Answers

I create user but i cant login the user i created.

I created a user, i login as a root. I add him in the group where he can access and login as a root! I checked it in users' list and in group's list, he is there. My problem is this, I cant login using the username/account I just created! What should i do to use and login the user/account i've just...

9. UNIX for Advanced & Expert Users

Other than root user .Normal user is unable to create files

Hi all, I am using Sun Solaris 9 .In this system normal users unable to create files from the command line.I added these users in bin,adm and even root group i found them unable to create a file.

Login or Register to Ask a Question