Re: Newbie DBA question (PLEASE HELP!)

From: Robert Martin <rwmartin_at_sisconet.com>
Date: Thu, 16 Nov 2000 16:06:44 -0500
Message-ID: <8v1iaq0q3s_at_enews3.newsguy.com>

Ok, when I try to use the wizard and set it up with the server name (which is the service name) and the user and password this is the error I get when I try to test connecting to the database.

"Test connection failed because of an error in initializing provider. ORA-01017: invalid username/password; logon denied."

Now, I can easily test the connection if I change the user name to "system" and the password to "manager". Everything works fine then. Also, I am having trouble granting users access to tables. It keeps telling me "Insufficient Privileges"

This really sucks because I have project that is supposed to use Oracle and the schedule is real tight (and my employer is too freaking cheap to send me to classes)

---

Robert Martin (rwmartin_at_sisconet.com) Design Engineer
SISCO Inc,
6605 19 1/2 Mile Road
Sterling Heights, MI 48314-1408
Phone : 810-254-0020 (ext 125)
Fax : 810-254-0053
"Alan" <alanshein_at_spambuster.erols.com> wrote in message news:8v1hj5$8p0$1_at_bob.news.rcn.net...
> What is the error message?
>
> "Robert Martin" <rwmartin_at_sisconet.com> wrote in message
> news:8v1f8g0kab_at_enews3.newsguy.com...
> > I just realized I can connect to the database using SQL Plus. The
 problem
> > is, I am trying to use the ATL Object Wizard in Visual Studio and it
 won't
> > allow that user to connect to the database. I have no idea what to do.
> > Anyone with Oracle/Visual Studio ATL Object Wizard please help. Thanks.
> >
> >
> > "Robert Martin" <rwmartin_at_sisconet.com> wrote in message
> > news:8v1dtc0i3k_at_enews3.newsguy.com...
> > > Ok. I am an idiot when it comes Oracle (and I am running on NT), just
 so
 you
> > > know ahead of time. I have managed (by stumbling greatly) to migrate
 an
 SQL
> > > database over into an Oracle database using a Migration Assistant from
> > > Oracle. Well, the sucker wouldn't convert to Oracle until I created a
> > > certain user in the database I was migrating it into. Well, I created
 the
> > > user and then everything migrated on over pretty well. But, since I
 don't
> > > know what privileges to assign to that user - I can't connect to the
> > > database as that user. I can connect as system, internal and sys and
 those
> > > are the only users that appear that can connect to the database. I
 don't
> > > know what to do! And can all the things I need to do be done in the
 OEM
 so
 I
> > > done have to monkey with a lame console application? Please someone
 help!
> > > Thanks!
> > >
> > > One more question too. What does Admin Option mean in reference to a
 Role,
> > > System Privilege or Object Privilege??
> > >
> > > -------------------------------------------
> > > Robert Martin (rwmartin_at_sisconet.com)
> > > Design Engineer
> > > SISCO Inc,
> > > 6605 19 1/2 Mile Road
> > > Sterling Heights, MI 48314-1408
> > > Phone : 810-254-0020 (ext 125)
> > > Fax : 810-254-0053
> > >
> > >
> >
> >
>
>
Received on Thu Nov 16 2000 - 22:06:44 CET