Home » RDBMS Server » Server Administration » How to create first database user ?
How to create first database user ? [message #232091] Thu, 19 April 2007 06:23 Go to next message
naimish_hit
Messages: 34
Registered: March 2007
Member
Hi,

I have created and mounted a database, right now I connect with it as sysdba, i.e.Connect / as sysdba.

Now I want to create dba and normal user, what should I do and how should I do ?

REgards,

Naimish

Report message to a moderator

Re: How to create first database user ? [message #232093 is a reply to message #232091] Thu, 19 April 2007 06:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm#16513

Report message to a moderator

Re: How to create first database user ? [message #232129 is a reply to message #232093] Thu, 19 April 2007 10:13 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
For DBA user assign DBA role (Predefined Role) .
For other user ,create seperate roles with required privilleges and assign to each user.

Report message to a moderator

Previous Topic: clone database
Next Topic: uninstall
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:44:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.