Question re connecting as sysdba

From: Bill Wagman <wjwagman_at_ucdavis.edu>
Date: Mon, 20 Nov 2000 17:04:33 -0800
Message-Id: <10686.122568@fatcity.com>

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.' Received on Mon Nov 20 2000 - 19:04:33 CST