Hi Mitchell,
what is different between those 3 login
1. sqlplus system login, connect as internal
Answer:
when you are doing this you are user 'sys'
because you have changed from system to being
'internal'
connect internal - technically is user 'sys', and is the way
of authenticating to the database
2. sqlplus system/manager login
Answer:
when you are doing this you are user 'system'
3. sqlplus system login , connect system as sysdba
Answer:
when you are doing this you are user 'system'
you have given 'system' sysdba privilege ( which
'system' can perform everything which is allowed for
sysdba privilege + on-top of the privileges that it already has)
importantly by logging this way 'system' can never be
equal to 'connect internal'
Thanks,
Kavi
mitchell wrote:
> Hi
>
> I just view readme about installing Oracle Patch on Oralce 8.1.6
>
> One thing mentioned as Invoke sqlplus, connect as internal and
> run
> catalog
> catproc
> etc ..
>
> I wonder why Connect as internal.
>
> what is different between those 3 login
>
> 1. sqlplus system login, connect as internal
> 2. sqlplus system/manager login
> 3. sqlplus system login , connect system as sysdba
>
> Thanks in advance
>
> Mitchell
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mitchell
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
begin:vcard
n:;Kavitha
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Kavitha Muthukumaren
end:vcard
