Oracle 11g - Create new user within Oracle

Posted on 2014-04-03
Last Modified: 2014-04-03
Although I've done it before, I don't create users within Oracle very often.  I know how to assign specific rights to a user but not how to create.  The user I want to create is called "AWBATCH".  Can someone help me with the syntax of this command?
Question by:akdreaming
LVL 23

Accepted Solution

paquicuba earned 250 total points
ID: 39976009
create user AWBATCH identified by <password>

Author Comment

ID: 39976021
I assume I put the password I want to assign in the brackets?
LVL 74

Expert Comment

ID: 39976102
yes, but without the brackets.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 39976120
Tobe able to actually connect to that user you need one more step:
grant create session to AWBATCH;

To be able to create objects:
grant resource to AWBATCH;

There are likely more grants you will need.  Like a TEMPORARY talbespace?  a default object tablespace?

Author Comment

ID: 39976226
Can I run a command to look up a password on a specific user?  Or is that a no-no?
LVL 74

Expert Comment

ID: 39976242
you can't find a user's password, they aren't stored.  Only hashes of them.
Where and how they are stored varies by version

for more information....
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 39976355
If you have DBA access, you can change someone's password without knowing his/her actual password.

Author Closing Comment

ID: 39976583
Great quick response.  Thanks folks for the help.  I hope to become more proficient in Oracle.  I'm making progress but a long way away from where you guys are.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL 6 73
su - oracle could not open session 6 95
PL SQL Developer 7 52
error in my cursor 5 41
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the dā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question