Pr.Pg Next Pg

Creating the new User using SQL Worksheet tutorials

 

  • SQL Developer as an Alternative for Creating Database Users:

  • If you have experience with SQL Developer, you can use it instead of the command line to create a database user, as follows:

  • Start SQL Developer.

  • This procedure varies by platform. In Windows, for example, choose Start > All Programs > Oracle

  • OraDb11g_home2 > Application Development > SQL Developer.

  • Now Oracle SQL Developer opens.

  • Create a database connection for the SYSTEM user, we have already created the connection demodatabase_conn.

  • Open that database connection demodatabase_conn. SQL Worksheet display on the right side.

  • Enter the following SQL Statement.

 

CREATE USER SMITH IDENTIFIED BY smith123

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

ACCOUNT UNLOCK ;

 

 

 

  • Now right click on the Other Users Select the Refresh, and Expand the Other Users, the new user (SMITH) will be display in the Other Users list which is shown in the below images:

 


Pr.Pg border                                              Next Pg