Re: Encryption Required

Re: Encryption Required

 

  

On Mon, 30 Jul 2007 12:23:49 -0500
"Israel Laureano Lazcano " <oracledba-ezmlmshield-x77565866.[Email address protected] wrote:

> Coordinating (making a certificate) two machines for using SSH (Secure
> SHell) or SCP (Secure CoPy) without asking for a password is not
> difficult, but its a little bit tricky and requires having the most
> recent versions of the OS in both machines.

1. Wrong! It's enough to have support of the same (or compatible, e.g. SSH1/SSH2) version of SSH protocol only (SSH2 is better!).

> The solution we use is having a NFS, so we can generate files and share
> them at the same time.

2. We use NFS as well, it's a good solution but for LANs only. It's very bad (security, bandwidth) solution for WAN/Internet.

> Israel.
>
> System Administrator escribi_:
>
> >FTP is a bad idea (from security poinyt of view) in any cases.
> >Try SSH with certificate and you'll be able send data without password (e.g. easy to send automatically etc).
> >
> >On Fri, 27 Jul 2007 22:50:34 +0530
> >"Gaurav Chaudhary " <oracledba-ezmlmshield-x34754032.[Email address protected] wrote:
> >
> >
> >
> >>Hi Friends,
> >>
> >>I have a typical requirement to encrypt the data of .CSV or text file Using
> >>Oracle and send it to client through FTP.
> >>
> >>Do we have any idea or anyone can provide me with any hint that how to do
> >>it.
> >>
> >>May be you can suggest any other technique either using perl or shell script
> >>or any other tool. But problem with the tool is that we need to schedule the
> >>report generation so if you suggest any tool then that should be able to
> >>incorporate in Scheduling task.
> >>
> >>Thanks in advance,
> >>Gaurav
> >>
> >>
> >>
> >>Gaurav Chaudhary Sr Database Administrator | Cybage Software Pvt Ltd. (An
> >>SEI CMMI Level 5 Company) | Marisoft, Kalyani Nagar | Pune, India - 411 006
> >>Ph: 91 20 6604-1700 (Ext: 2810) | Fax: 91 20 6604-4701 | Mail To:
> >>[Email address protected] | www.cybage.com
> >>----- Original Message -----
> >>From: "Stephen Price "
> >><oracledba-ezmlmshield-x40110299.[Email address protected]
> >>To: "LazyDBA Discussion" <[Email address protected]
> >>Sent: Friday, July 27, 2007 10:13 PM
> >>Subject: Error PLS-00201: identifier 'X$KGLOB' must be declared
> >>
> >>
> >>
> >>
> >>>What is X$KGLOB and what do I have to do to get it into my DB instance?
> >>>
> >>>
> >>>
> >>>Query 'select owner, object_name, object_type from all_objects where
> >>>object_name like '%KGLOB%';' returns no results...
> >>>
> >>>
> >>>
> >>>DBMS is 10.2.0.2 on Win32
> >>>
> >>>
> >>>
> >>>Cheers,
> >>>
> >>>Stephen
> >>>
> >>>
> >>>
> >>>Stephen Price
> >>>Oracle Database Administrator
> >>>Compusearch Software Systems, Inc.
> >>>(o) 703.481.3699 x383
> >>>(f) 703.481.3442
> >>>21251 Ridgetop Cir, Suite 100
> >>>Dulles, VA 20166
> >>>[Email address protected] | www.compusearch.com
> >>><http://www.compusearch.com/>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>---------------------------------------------------------------------
> >>>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> >>>To post a dba job: http://jobs.lazydba.com
> >>>To Subscribe : http://www.LazyDBA.com
> >>>To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >>>
> >>>
> >>>
> >>>
> >>
> >>---------------------------------------------------------------------
> >>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> >>To post a dba job: http://jobs.lazydba.com
> >>To Subscribe : http://www.LazyDBA.com
> >>To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >>
> >>
> >>
> >>
> >>
> >
> >
> >---------------------------------------------------------------------
> >TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> >To post a dba job: http://jobs.lazydba.com
> >To Subscribe : http://www.LazyDBA.com
> >To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>

Oracle LazyDBA home page