Re: question about users

From: Jim Cheng <jinxcheng_at_hotmail.com>
Date: Mon, 29 Nov 2004 20:39:24 -0800
Message-ID: <cogti4$kvo$1@news.Stanford.EDU>

Michel is right. You can confirm by using the following command:

SQL>show user

It will tell you that you connect as SYS

Jim

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:41ab69b1$0$27035$636a15ce_at_news.free.fr...
>
> "Markus Innerebner" <markusin_at_yahoo.de> a écrit dans le message de
> news:31160uF34bt0tU1_at_uni-berlin.de...
>> While installing oracle9i I came to the question:
>>
>> if I start
>> sqlplus /nolog
>> then
>> conn / as sysdba
>>
>> how does oracle know, if the logged in user is a sysdba?
>> Does he know it from the unix-users?
>>
>> thanks for your help
>>
>> Markus
>
> If you connect with this syntax you are connected as SYS.
> You can do this only if you are in the Unix dba group.
> So yes, Oracle knows it from the connected Unix user.
>
> Have a look at "Database Administrator Authentication" in Administrator's
> Guide:
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1064
>
> Regards
> Michel Cadot
>
>
Received on Mon Nov 29 2004 - 22:39:24 CST