Re: Question re connecting as sysdba

From: zhuchao <zhuchaopku_at_263.net>
Date: Tue, 21 Nov 2000 13:12:03 +0800
Message-Id: <10686.122581@fatcity.com>

Bill Wagman=A3=AC=C4=FA=BA=C3=A3=A1

    Maybe you r using os authentication, and connect to os as=  oracle.
=09is that true?

=D4=DA 2000-11-20 17:00:00 =C4=FA=D0=B4=B5=C0=A3=BA
>Hello,
>
>I believe I am missing something quite basic here. Using Oracle=
 server
>enterprise edition v8.1.6.2.0 on Solaris 7 a user has been=
 granted the
>following...
>
>connect
>resource
>create public synonym
>drop public synonym
>unlimited tablespace
>
>In sql*plus I do the following...
>
>connect user/password as sysdba
>
>and I am sucessfully connected. Now I can shut down the=
 database. How do I
>prevent this non-dba user from connecting as sysdba?
>
>Thanks.
>
>Bill Wagman
>Univ. of California at Davis
>Information Resources
>wjwagman_at_ucdavis.edu
>(530) 754-6208
>
>----------------------------------------------------------------=

---

>I like to pick up hitchhikers. When they get in the car I say,=
 'Put on your
>seat belt. I want to try something. I saw it once in a cartoon,=
 but I think
>I can do it.'
>- Steven Wright
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bill Wagman
> INET: wjwagman_at_ucdavis.edu
>
>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: ListGuru_at_fatcity.com (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).

                    =D6=C2

=C0=F1=A3=A1 Received on Mon Nov 20 2000 - 23:12:03 CST