Re: oracle 9i connection string with SYS account

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 4 Jun 2002 13:11:08 +0200
Message-ID: <adi7bn$qoa$1@crusher.de.colt.net>

"Bertus Dam" <b.dam_at_gmx.net> schrieb im Newsbeitrag news:3cfc9fe0_at_news.mhogaming.com...
>
> I'm trying to create a connectionstring in my application to an oracle 9i
> database.
> I can't get it to work though. This is what I try:
>
> Provider=OraOLEDB.Oracle;Data Source=svr;User
> ID=SYS;Password=change_on_install;
>
> Errormessage:
>
> Message: "ORA-28009: connection to sys should be as sysdba or sysoper"
>
> How can I fix this? Or how do I create a connectionstring which uses
> integrated O/S security?

Do not use SYS, create a new user. If the user needs access to sys objects grant dba to the new user.

Regards,

Knut Received on Tue Jun 04 2002 - 06:11:08 CDT