Re: Enterprise 8i on linux - default dba?

you have to connect AS sysdba. I.e in normal usage the sys user will get insufficient privileges on requesting shutdown.

eg in sqlplus

connect sys/sysdba as sysdba will grant rights to stop the db connect system/manager as sysdba should not work

UNLESS you are using operating system authentication in which case your privileges are dependent upon your os account. In this situation connect / as sysdba will work. These are covered I believe in the oracle concepts manual and certainly in the Oracle 8i Complete reference and the Oracle DBA Handbook both of which any dba should have.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<gerald_bastin_at_my-deja.com> wrote in message
news:91qjdp$47q$1_at_nnrp1.deja.com...


> Hummm your post scare me because my sys user doesn't have rights to

> stop my database. By the way System cannot stop it either.

> It seems that nobody can stop it..... May I have a problem. How can I

> check it ?

>

> In article <91q64b$g2a$1_at_soap.pipex.net>,

>   "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

> > as oulined in sybrands post sys is more powerful than system.

 sys/internal -


> > you can think of them as the same account for most purposes - has

 sysdba


> > privileges, whereas system doesn't. This means for example that sys

 can


> > startup/shutdown the db and perform incomplete recovery - system

 cannot.


> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > <gerald_bastin_at_my-deja.com> wrote in message

> > news:91pvi8$kn1$1_at_nnrp1.deja.com...

> > > Is certainly the first question I have asked to myself when I saw

 the


> > > login screen. I have a nice database but how can I log to it ?

> > > There is 2 buit-in users with Oracle

> > > system with password manager

> > > sys with password change_on_install

> > >

> > > System seems to have more rights than sys so he is more powerful.

> > >

> > > I don't know more, I am a newbie trying to understand the great

 world


> > > of Oracle !

> > >

> > > Regards

> > >

> > > Gérald Bastin

> > >

> > > In article <3a40582f_at_monitor.lanset.com>,

> > >   "John McClain" <jmcclain1_at_lanset.com> wrote:

> > > > I have installed enterprise 8i on suse linux 7.0. The install

 appears
 to


> > > > have been successfull. ( how can I really tell for sure??)

> > > > BUT, I would like to have access to the database I just installed!

> > > > Throughout the entire isntall process ( using the universal

 installer) I


> > > > never once was give a user and password for a login to sqlplus.

 Should there


> > > > be one? where could I find it? Do I need to setup db accounts

 using
 another


> > > > tool? if so what tool?

> > > > The issue is that when I type sqlplus, it prompts me for a user

 and
 login


> > > >  makes sense) but I don't have one, so it returns 'invalid

 login/password


> > > > ...' Anyone out there that can help???

> > > >

> > > > --

> > > > John and Michelle McClain

> > > > 7604 Muschetto Ct.

> > > > Citrus Heights, Ca. 95621

> > > > (916)728-5223

> > > >

> > > >

> > >

> > >

> > > Sent via Deja.com

> > > http://www.deja.com/

> >

> >

>

>

> Sent via Deja.com

> http://www.deja.com/