Re: SYSDBA account

From: Van Messner <vmessner_at_netaxis.com>
Date: Mon, 2 Nov 1998 17:34:19 -0500
Message-ID: <Suq%1.474$as6.1357@news14.ispnews.com>

Hello:

I'm not sure what you mean by a sysdba account. User SYSTEM is a dba, user SYS is god. If you use Svrmgr and connect internal you can startup and shutdown your database. With the enterprise edition you also got enterprise manager. You can use that or statements in Svrmgr to create a user and grant him many possible roles and permissions including the DBA role. Hope this helps.

Van

rosek_at_my-dejanews.com wrote in message <71l8on$qd2$1_at_nnrp1.dejanews.com>...
>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 - 16:34:19 CST