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.
In the connection, right-click the schema or anything in it, and select New.
From the New Gallery, in Filter By, choose All Technologies.
From the New Gallery, in Categories , expand Database Tier and choose Database Objects.
From Database Objects, choose User and click OK to open the New Database User wizard.
In the pages of the wizard enter parameters and select options to define the table.
Click Next.
On the Finish page, click Finish to create the table.

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, available from the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.