Home arrow Oracle arrow Page 3 - Six Must Know Oracle Commands

The Oracle SQL Create User/Grant Command - Oracle

Oracle is one of the top relational databases in the world and has been used by Fortune 500 companies such as Exxon Mobil, Wal-mart, General Electric and many others. In this tutorial, we will show you six "must know" Oracle SQL commands.

TABLE OF CONTENTS:
  1. Six Must Know Oracle Commands
  2. The Oracle SQL Connect Command
  3. The Oracle SQL Create User/Grant Command
  4. The Create Table, Insert, and Select Oracle SQL Commands
By: Codex-M
Rating: starstarstarstarstar / 5
March 16, 2011

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
 

Third Command: CREATE USER/GRANT COMMAND

It's not recommended to use SYSTEM user during your actual work (like creating tables, doing queries, etc) within the Oracle database. For that, you should create a new admin user. To do this, you need to use the CREATE USER and GRANT command:

1.) Suppose you want to create a new Oracle database administrator named “new_admin” with a password “adminpassword”. In the SQL*plus command line, issue the CREATE USER command in the SQL prompt:

SQL> CREATE USER new_admin IDENTIFIED BY adminpassword
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;


Then press the Enter key.

2.) To grant database administrator privileges to “new_admin”, you need to use the grant command:

SQL> GRANT connect, resource, dba to new_admin;

If this command is successful you will then see, “Grant succeeded”.



 
 
>>> More Oracle Articles          >>> More By Codex-M
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: