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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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.
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

LVL 77

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

726 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