Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDBA account
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