?
Solved

Oracle 11g - Create new user within Oracle

Posted on 2014-04-03
8
Medium Priority
?
628 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 23

Accepted Solution

by:
paquicuba earned 1000 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

777 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