From jyotiseth2001@gmail.com Fri Jun  19 10:49:55 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D2711632F4A
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 19 Jun 2009 07:49:55 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 51107-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 19 Jun 2009 07:49:54 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.172])
	by mail.postgresql.org (Postfix) with ESMTP id 45FB462DCFD
	for <pgsql-sql@postgresql.org>; Fri, 19 Jun 2009 07:49:54 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 28so793088wfc.28
	for <pgsql-sql@postgresql.org>; Fri, 19 Jun 2009 03:49:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:from:to:subject:date
	:message-id:mime-version:content-type:x-mailer:thread-index
	:content-language:x-cr-hashedpuzzle:x-cr-puzzleid;
	bh=Vt83Zi3WsX0lf3jqXmL+glCQoN/YRzN46A8aWKOTj3M=;
	b=WhEcesgaBbxuZBU9Qm7+gVmMn70qhp3ywNeU/5BsNRNOfiDMoJadLbfoP+ZfJBabx+
	TGyE1w164Knmz5jEYZal1cJ1tg11Eb1yzNsyJ+6zY0aBgcRJ4oz+njl8nzMLIpMzRN+P
	Y4jP+vAkEpRR2cLcd4wo6nYLRhYc13xNsVk0o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:to:subject:date:message-id:mime-version:content-type:x-mailer
	:thread-index:content-language:x-cr-hashedpuzzle:x-cr-puzzleid;
	b=rZxkOk0HzshGLNZ65D+BZzkBh+R2a3Q9hrfa8KXS+EOk0ecfyavqkanaN4OLnsHdlU
	EVlPClOC6fbHkR5vZJMApRBUFHG3hoYKI6rVS3bozpLej8efmUJ/fAMrRQXikMwFF9ez
	pw63S6l0NuMCg1RzJe2JihxrKyQgPWFNIk7uA=
Received: by 10.142.169.4 with SMTP id r4mr1371883wfe.105.1245408592593;
	Fri, 19 Jun 2009 03:49:52 -0700 (PDT)
Received: from BITDLLT03 ([122.160.72.188])
	by mx.google.com with ESMTPS id 22sm364891wfg.27.2009.06.19.03.49.49
	(version=SSLv3 cipher=RC4-MD5); Fri, 19 Jun 2009 03:49:52 -0700 (PDT)
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: <pgsql-sql@postgresql.org>
Subject: SQL File in encrypted form
Date: Fri, 19 Jun 2009 16:10:34 +0530
Message-ID: <000001c9f0ca$7935f890$6ba1e9b0$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0001_01C9F0F8.92EE3490"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcnwylyobmhFkRYpTrCgbyDUUVT5UA==
Content-Language: en-us
x-cr-hashedpuzzle: AF1L BH6H BMDJ BYAH CJkn CSAD DWIq EFSS Fii2 Goc7 Is7S JJ2f
	JOjs JUmX K91y MFFO; 1;
	cABnAHMAcQBsAC0AcwBxAGwAQABwAG8AcwB0AGcAcgBlAHMAcQBsAC4AbwByAGcA;
	Sosha1_v1; 7; {5CA93CDD-B1DD-43AC-8BF8-40084FF6A398};
	agB5AG8AdABpAHMAZQB0AGgAMgAwADAAMQBAAGcAbQBhAGkAbAAuAGMAbwBtAA==;
	Fri, 19 Jun 2009 10:40:28 GMT;
	UwBRAEwAIABGAGkAbABlACAAaQBuACAAZQBuAGMAcgB5AHAAdABlAGQAIABmAG8AcgBtAA==
x-cr-puzzleid: {5CA93CDD-B1DD-43AC-8BF8-40084FF6A398}
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200906/88
X-Sequence-Number: 32693

This is a multipart message in MIME format.

------=_NextPart_000_0001_01C9F0F8.92EE3490
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi All,

 

I want to send the sql script file to a client but wants to hide the details
in it. Can I send the sql script file in encrypted form which they can
execute but can't view the details.

 

Thanks,

Jyoti


------=_NextPart_000_0001_01C9F0F8.92EE3490
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>Hi All,<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I want to send the sql script file to a client but =
wants to
hide the details in it. Can I send the sql script file in encrypted form =
which
they can execute but can&#8217;t view the details.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Thanks,<o:p></o:p></p>

<p class=3DMsoNormal>Jyoti<o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_000_0001_01C9F0F8.92EE3490--




From jasen@xnet.co.nz Fri Jun  19 13:36:51 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3AC30633D87
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 19 Jun 2009 10:36:51 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 82611-05 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 19 Jun 2009 10:36:49 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from titania.wxnz.net (titania.wxnz.net [58.28.4.13])
	by mail.postgresql.org (Postfix) with ESMTP id 10836633D2B
	for <pgsql-sql@postgresql.org>; Fri, 19 Jun 2009 10:36:49 -0300 (ADT)
Received: from gonzo (ip-118-90-143-151.xdsl.xnet.co.nz [118.90.143.151])
	by titania.wxnz.net (Postfix) with ESMTP id 1574F1DB81CC
	for <pgsql-sql@postgresql.org>; Sat, 20 Jun 2009 01:36:45 +1200 (NZST)
Received: from news by gonzo with local (Exim 4.69)
	(envelope-from <news@reversiblemaps.ath.cx>) id 1MHeGn-0005xP-41
	for pgsql-sql@postgresql.org; Sat, 20 Jun 2009 01:36:41 +1200
To: pgsql-sql@postgresql.org
Path: not-for-mail
From: Jasen Betts <jasen@xnet.co.nz>
Newsgroups: gmane.comp.db.postgresql.sql
Subject: Re: SQL File in encrypted form
Date: 19 Jun 2009 13:36:40 GMT
Organization: Dis (not Dat) Organisation
Lines: 24
Message-ID: <h1g498$lig$2@reversiblemaps.ath.cx>
References: <000001c9f0ca$7935f890$6ba1e9b0$@com>
NNTP-Posting-Host: localhost
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: reversiblemaps.ath.cx 1245418600 22096 127.0.0.1 (19 Jun 2009
	13:36:40 GMT)
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-2 (Linux)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200906/89
X-Sequence-Number: 32694

On 2009-06-19, Jyoti Seth <jyotiseth2001@gmail.com> wrote:
> This is a multipart message in MIME format.
>
> ------=_NextPart_000_0001_01C9F0F8.92EE3490
> Content-Type: text/plain;
> 	charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hi All,
>
>  
>
> I want to send the sql script file to a client but wants to hide the details
> in it. Can I send the sql script file in encrypted form which they can
> execute but can't view the details.

only by building it into an encrypted executable.
be sure to use SSL on the database connection.

or possibly you could write a backend extension (stored procedure
writtern in C, Java, or other compiled language) that does 
decrypting and execution in a single step and use that. 

what sort of things are you trying to hide?