Re: Help on SYSDBA previliege

Sounds like you have OS authentication.

If you are logged in as someone in the dba group you can run sqlplus and connect as SYSDBA. You can give an name and password and it will work so long as you are logged in as a dba group member at OS level.

So when you do CONNECT mike/mike AS SYSDBA it is SYS who connects not mike..

hth
Lawrence

"Yang Hou" <yanghou_at_lucent.com> wrote in message news:9p1dgh$fjh_at_nntpa.cb.lucent.com...
> Hi,
>
> I installed Oracle8i dtabase on HP 9000 server,then I create a general
user
> name "mike" ( Oracle account) with password "mike". I only grant "create
> session" previliege to this user, but when I log in using this account , I
> find I can run "CONNECT mike/mike AS SYSDBA". This make me feel strange,
> cause I haven't grant any role and SYSDBA administrator previliege
> "Mike"."Mike" is only a Oracle account and doesn't belong default user
group
> "dba".
>
> In Oracle 9i Administrator Guide( PDF from Oracle official site), there is
> one sentence "Control of these privileges is totally outside of the
database
> itself."( chapter 1, Page 1-13 ), I don't know its mean and can not find
> more clear description about this.
>
> Any assistance is appreciated!
>
>
Received on Fri Sep 28 2001 - 10:08:41 CDT