Creating database users in Oracle

For Oracle applications, the first step to establishing user security is to create user IDs and passwords within Oracle. You must have sufficient access to Oracle to be able to create other users and grant them access to complete the steps in this section. In addition to creating users, you must also assign temporary tablespace.

If you are performing this task, you can follow the instructions provided here, but you must be able to sign in to Oracle with administrative privileges. You can use the SQL Worksheet, which is found on your client desktop, or the Security Manager, which is part of the Oracle Enterprise Manager program group on your Oracle server. Only the SQL Worksheet procedure is documented here.