How to create user in Oracle 9i

Question

How to create user in Oracle 9i

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

kanejhons SSC Rookie Points: 28 More actions · Answer 1

Hello Friends...........

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:

1.Password

2.External

3.Global

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.

Thanks

adi backoffice

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 2

kanejhons (10/16/2010)
10.Assign roles to the new user.

There is a particular privilege you must grant in Ora11g, don't you?

Does CREATE SESSION rings a bell?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.