Creating Users

The user name you use to create a connection must have adequate privilege to create a user, either by having been granted CREATE USER privilege or having been granted a role such as administrator that contains that privilege. If you did not create the connection with a user with the correct privileges, you will not be able to select User from the New Gallery.

To create a user:

Select View Connection Navigator.
Expand Database and select a database connection.
Right-click the connection or anything in it, and choose New to open the New Gallery.
In the New Gallery, if the Database Tier is not visible in Categories, in Filter By, choose All Technologies.
In Categories, expand Database Tier and select Database Objects.
From Database Objects, select User and click OK to open the Create User dialog.
In the dialog enter parameters and select options to define the user.

For information about how to fill in values for the the wizard parameters and options, click Help in the dialog, or see the CREATE USER section of the Oracle Database SQL Reference at http://www.oracle.com/technology/documentation/database10g.html.

Context Menu Shortcut:

From the Connections Navigator, select the Users folder in a schema and right-click it, then select New User .