Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDBA account

Re: SYSDBA account

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Mon, 02 Nov 1998 23:20:39 GMT
Message-ID: <b7r%1.15970$h45.10999934@news.rdc1.az.home.com>


Fair warning: CONNECT INTERNAL is documented as going away as of Oracle 8.1, so I wouldn't be training anyone new on how to use it...

Van Messner wrote in message ...
>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 - 17:20:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US