• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 632
  • 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?
0
akdreaming
Asked:
akdreaming
2 Solutions
 
paquicubaCommented:
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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?
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 VirdiCommented:
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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