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/
Received on Wed Dec 20 2000 - 05:45:09 CST
