Solved

Oracle 11g - Create new user within Oracle

Posted on 2014-04-03
8
602 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
Comment Utility
create user AWBATCH identified by <password>
0
 

Author Comment

by:akdreaming
Comment Utility
I assume I put the password I want to assign in the brackets?
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
yes, but without the brackets.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:akdreaming
Comment Utility
Can I run a command to look up a password on a specific user?  Or is that a no-no?
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
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
Comment Utility
If you have DBA access, you can change someone's password without knowing his/her actual password.
0
 

Author Closing Comment

by:akdreaming
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now