Re: connect as sysdba

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 5 Jan 2001 06:41:20 +0100
Message-ID: <935hjg$8ro3s$1@ID-62141.news.dfncis.de>

If he is on the O/S side in the dba group (Unix default) or ora_dba group (NT) he has sysdba by design!
You could also verify the init.ora parameter remote_login_password_file. If I understand you correctly chances are this has been set to exclusive, and you want it to be shared (sys and internal have sysdba) or even none (only internal has sysdba). If this doesn't apply you need to make sure the user logs in on the O/S side as a non dba user.

Hth,

Sybrand Bakker, Oracle DBA

Hth
"Montserrat Mateos" <m.mateos_at_upsa.es> wrote in message news:3a549ea5$1_at_193.146.156.23...
> I have a problem with oracle, I create a new user and although he hasn´t
> privilegies as sysdba, he can connect as sysdba, can i do to deny this
> privilegie
>
> Thanks
>
>
>
>
Received on Thu Jan 04 2001 - 23:41:20 CST