Create USER Oracle Database Tutorial Example

How To Create USER In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to create user in Oracle Database Server as SYSDBA Tutorial Example

-- connect as sysdba
-- i am using sqlplus as client. you can use anything as you like.
 
   CREATE USER TUTORIAL IDENTIFIED BY TUTORIAL;
      -- that's it!! Oracle database user "TUTORIAL" with password "TUTORIAL" has been created
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Create USER In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Drop USER In Oracle Database Tutorial Example
  2. How To GRANT a USER In Oracle Database Tutorial Example
  3. How To REVOKE ROLE from a USER In Oracle Database Tutorial Example
  4. How To Disconnect From Oracle Database Tutorial Example
  5. How To Create Table In Oracle Database Tutorial Example
  6. MySQL NULLIF() Function Boolean Value Example
  7. How To Find MySQL SERVER VERSION Information
  8. 19 Examples to Learn MySQL
  9. 20 Steps to Learn CakePHP by Example
  10. UNIX Command Example: File Last Modification UTC GMT Information

No comments:

Post a Comment

leave your comments here..