could any one tell me that, How to create new user in oracle?
I know the command,
But if I give this command on /Home$ prompt, I am getting error as,
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
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 )
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? (3 Replies)
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:... (5 Replies)
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;... (2 Replies)
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... (12 Replies)
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... (0 Replies)
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! (6 Replies)
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 (1 Reply)
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... (5 Replies)
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. (1 Reply)