Oracle 11g - Create new user within Oracle

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?
akdreamingAsked:
Who is Participating?
 
paquicubaConnect With a Mentor Commented:
create user AWBATCH identified by <password>
0
 
akdreamingAuthor Commented:
I assume I put the password I want to assign in the brackets?
0
 
sdstuberCommented:
yes, but without the brackets.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
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
 
akdreamingAuthor Commented:
Can I run a command to look up a password on a specific user?  Or is that a no-no?
0
 
sdstuberCommented:
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
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
If you have DBA access, you can change someone's password without knowing his/her actual password.
0
 
akdreamingAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.