Date:         Thu, 15 Jul 2004 08:08:13 -0700
Reply-To:     "Pardee, Roy" <pardee.r@GHC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Pardee, Roy" <pardee.r@GHC.ORG>
Subject:      Re: connecting and reading encrypted data from oracle
Comments: To: "Miller, Scott" <smiller@WVMI.ORG>
Content-Type: text/plain; charset="us-ascii"

I would bet that the decryption will be handled at the oracle client
level & you won't need to change your practices at all (tho you may have
more time on your hands as you wait not only for data to come across the
wire, but for the decryption step as well).

Have you posed this question to your DBA?

Cheers,

-Roy

P.S. Do I recognize your P.T. Barnum quote from an episode of the
Simpsons?

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Miller, Scott
Sent: Thursday, July 15, 2004 6:38 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: connecting and reading encrypted data from oracle


i am just getting sas 9.1.2 installed and also just found out that an
oracle database i am using will be encrypted soon.  i connect now to
oracle with a libname statement, so my question is how do i connect to
this new oracle dbase once it is encrypted?  i typically use data steps
to access data and rarely use sql.  thanx.

Scott D. Miller, MA

Evaluation and Informatics Analyst
West Virginia Medical Institute
(304) 346-9864 ext 2240

Every good scientist should be one part P.T. Barnum and one part B.F.
Skinner.

Sumus quid sumus

...and why did I leave the plow in the field, and look for a job in the
town