• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 640
  • Last Modified:

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?
2 Solutions
create user AWBATCH identified by <password>
akdreamingAuthor Commented:
I assume I put the password I want to assign in the brackets?
yes, but without the brackets.
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

slightwv (䄆 Netminder) 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?
akdreamingAuthor Commented:
Can I run a command to look up a password on a specific user?  Or is that a no-no?
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....

Devinder Singh VirdiLead Oracle DBA TeamCommented:
If you have DBA access, you can change someone's password without knowing his/her actual password.
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.
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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now