Re: Multiple connections?

["Williams, Wes HS-SNS" <wes.williams@HS.UTC.COM>]

So you run this outside of Maximo?

Wes Williams
Hamilton Sundstrand
815.226.6196


-----Original Message-----
From: Philippe Godin [mailto:philippe.godin@VIDEOTRON.CA]
Sent: Friday, June 01, 2001 12:34 PM
To: SQR-USERS@list.iex.net
Subject: Multiple connections?


Good day,

    Does anyone knows if there's a way to open a new connection to an Oracle
database using SQR?
This is my problem, using Oracle 8.1.5 and up, I'm trying to create a
temporary table in which I need to put several informations for further
processing.
If an user isn't  granted with the appropriate privileges I can the
following error : (SQR 5528) ORACLE OPARSE error -1031 in cursor 1:
   ORA-01031: insufficient privileges (which is totally normal).

This is what I looking to achieve. When the software we sell is installed it
creates a user Maximo which have all the privileges needed.
I would want SQR to switch to this user even if it's connected on another.
This way I could get all the advantages of using a temp table instead of an
array. I know we could deal with our customer's DBA to grant these
privileges to all the users which will use this report but we're trying to
keep it as much user-friendly as possible.

I've tried in a Begin-sql statement to do the following: connect
maximo/maximo@sco; but it doesn't work (though it works under SQL*PLUS 8.0;

Anyone have a great idea? I'm sure Oracle though of something that would be
secure and efficient...