Date:         Fri, 6 Feb 2004 13:00:28 -0500
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Insert Data using libname
Comments: To: Basem <batawfic@YAHOO.COM>
Content-Type: text/plain

Basem:
For some reason this reply to Harry did not post to SAS-L:
Harry:
If I recall it correctly, the SCHEMA parameter in a connection string
identifies databases.

From SAS technical support:
'....when connecting to a database with userid=SCOTT, by default you have
access to all objects in the SCOTT schema. However, if you want access to
objects in another schema, ie. DBITEST, then you must use SCHEMA=DBITEST on
the Access LIBNAME engine.' See
http://support.sas.com/techsup/technote/ts624.html

This note suggests that Basem needs to include a schema parameter value in
the LIBNAME statement if his usual schema does not include the target
database. (You may have been suggesting that in your off-list note to me.)
Sig -----Original Message-----
From: Droogendyk, Harry [mailto:Harry.Droogendyk@CIBC.COM]
Sent: Thursday, February 05, 2004 2:14 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Insert Data using libname


-----Original Message-----
From: Basem [mailto:batawfic@YAHOO.COM]
Sent: Friday, February 06, 2004 11:47 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Insert Data using libname


Clarification

I do not have a problem in writing the libname, the one I wrote was mock
just to focus on the important issue that i do not want to use my username,
but rather use user2 username.

libname bndwprod ORACLE schema=bndwprod user=&username password=&bndwpass
path='bndwprod.world' dbindex=yes REREAD_EXPOSURE=YES;

user1 do NOT have privileges to insert.
user2 whom I know his password DO have privileges.

now while I'm login as user1, I want to insert into the table using user2 in
my libname.