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
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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm#16513
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.
Previous Topic: clone database
Next Topic: uninstall
Goto Forum:
  


Current Time: Thu Dec 08 08:49:45 CST 2016

Total time taken to generate the page: 0.10185 seconds