Here's an easy way to create a new user life in Oracle9i by using Security Manager. If you have Security Manager open already, skip Step 1.
1. Start Console in stand-alone mode, double-click the Databases folder, double-click the database you want to work on, and log in as the DBA user (if necessary).
2. Choose Object --> Create.
You see the Create On window, where you decide what kind of thing you are creating.
3. Choose User and then click Create.
The Create User dialog box appears, as shown in Figure 1. This is not really a wizard, but it should be, because creating new life definitely is in the realm of wizards.
4. In the Name box, type a name for the new user.
Oracle has rules about what you use for a user name. You can use up to 30 characters. A letter and a single-digit number each count as one character. The same rules apply to setting up passwords
5. Choose the type of authentication.
For the example, choose Password authentication. You can click the arrow in the Authentication box to see the three choices:
6. In both the Enter Password box and the Confirm Password box, type the password.
The password appears on the screen as a line of asterisks (*).
7. Select or don't select the Expire Password Now check box.
If you select the box, users must enter a new password the first time they log in to the database.
8. Select a default tablespace.
9.Select the status for the new user.
10.Assign roles to the new user.
11.Click the Create button.