Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to create user in Oracle 9i Expand / Collapse
Author
Message
Posted Friday, May 29, 2009 9:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 6, 2011 10:51 AM
Points: 21, Visits: 86
if your DBA haven't change the default password for system then use the default password which is 'manager' (system/manager@dbname) then execure the create user command...
Post #725881
Posted Monday, June 1, 2009 10:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 5, 2013 2:53 PM
Points: 24, Visits: 123
You are on the right track. Make sure that the account you are logged into has "DBA" role. Then use the create user command. If you have privileges, it will work. If you want to connect to the DB as this user, especially using SQLPlus, you also need to grant the "CREATE SESSION" privilege to the user.

Good Luck!
(Oracle 9i is still alive and well)
Post #726815
Posted Monday, June 1, 2009 2:31 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
doug.williams (6/1/2009)(Oracle 9i is still alive and well)


Actually, Oracle 7 is still alive and well


_____________________________________
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.
Post #726980
Posted Thursday, April 1, 2010 2:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 27, 2013 10:33 PM
Points: 9, Visits: 641
what is the review for oracle 11i in today's market
Post #894492
Posted Thursday, April 1, 2010 10:31 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
dhaval_dsa (4/1/2010)
what is the review for oracle 11i in today's market

easy money... nobody uses 11i 'cause it doesn't exist


_____________________________________
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.
Post #895033
Posted Saturday, October 16, 2010 12:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 19, 2010 9:57 PM
Points: 4, Visits: 3
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
Post #1005665
Posted Monday, October 18, 2010 6:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1006168
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse