Create new username in oracle

To create a new username in Oracle, you can use the following steps:

*Using SQLPlus:**

1. Open a SQL*Plus session by typing sqlplus and pressing Enter.
2. Log in to the database using your existing username and password.
3. Use the following command to create a new username:

   CREATE USER <new_username> IDENTIFIED BY <password>;

   Replace <new_username> with the desired username and <password> with the desired password.

For example:

CREATE USER mynewuser IDENTIFIED BY mynewpassword;

4. Press Enter to execute the command.

Using Oracle Enterprise Manager:

1. Log in to Oracle Enterprise Manager using your existing username and password.
2. Click on the "Security" tab.
3. Click on "Users" and then click on "Create User".
4. Enter the desired username and password in the corresponding fields.
5. Click on "Create" to create the new username.

Using Oracle Net Manager:

1. Log in to Oracle Net Manager using your existing username and password.
2. Click on the "Security" tab.
3. Click on "Users" and then click on "Create User".
4. Enter the desired username and password in the corresponding fields.
5. Click on "Create" to create the new username.

Note:

• The new username must be unique and not already in use in the database.
• The password must meet the password complexity requirements set by your database administrator.
• The new username will have no privileges by default. You will need to grant privileges to the new username using the GRANT command.

For example:

GRANT CONNECT, RESOURCE TO mynewuser;

This grants the new username the ability to connect to the database and use the RESOURCE schema.