Re: SYSDBA account

OK, you want to set up users with sysdba and sysoper rights, in keeping with Oracle's removal of connect internal.

Here's what you do:

Create the password file:

ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users

Set the Remote_Login_Passwordfile initialization paramet to exclusive (and bounce the database).

Now you are ready to grant sysdba or sysoper to users:

grant sysdba to scott;

rosek_at_my-dejanews.com wrote:
: I am using Oracle 8 Enterprise Edition. I dont seem to have a SYSDBA account
: or SYSDBA role which I need to start up and shut down the database.

: Are these suppose to be created when you install ?
: If so what is SYSDBAs default password?
: Is there a script I must run to create this user ?

: How can I create a SYSDBA user with priviledges to shutdown and start
: database?

: If someone can point me to the prpoer oracle docs or provide a soltuion would
: be a bonus.

: Thanks :)

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

-- Received on Mon Nov 02 1998 - 17:48:48 CST