Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to create user in Oracle 9i


How to create user in Oracle 9i

Author
Message
aj-753163
aj-753163
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
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...
doug.williams
doug.williams
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 127
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)
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3093 Visits: 4639
doug.williams (6/1/2009)(Oracle 9i is still alive and well)


Actually, Oracle 7 is still alive and well :-D

_____________________________________
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.
dhaval_dsa
dhaval_dsa
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 641
what is the review for oracle 11i in today's market
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3093 Visits: 4639
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 :-D

_____________________________________
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.
kanejhons
kanejhons
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3093 Visits: 4639
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search