Creating a User with Interactive SQL

The DBA or user with USER ADMIN authority can create new users using the CREATE USER statement.

1. From Interactive SQL, connect to the database as a user with DBA or USER ADMIN authority.
2. Issue the CREATE USER statement.
   This example adds user ID M_Haneef to a database with password welcome.

   CREATE USER M_Haneef
   IDENTIFIED BY welcome