Re: oracle 9i connection string with SYS account

OK, but help me out here, I've created a user with DBA privileges. But when I issue a "create database" statement I get an error stating I have insufficient privileges. How can I create a user who can create databases too?

thanx, Bertus

"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:adi7bn$qoa$1_at_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:57:46 CDT