Solved

Oracle 11g - Create new user within Oracle

Posted on 2014-04-03
8
619 Views
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?
0
Comment
Question by:akdreaming
8 Comments
 
LVL 23

Accepted Solution

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

Author Comment

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

Expert Comment

by:sdstuber
ID: 39976102
yes, but without the brackets.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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?
0
 

Author Comment

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

Expert Comment

by:sdstuber
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....

http://www.experts-exchange.com/Database/Oracle/A_855-How-Oracle-Stores-Passwords.html
0
 
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.
0
 

Author Closing Comment

by:akdreaming
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

730 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