Encrypting information put into the database

Hi,

I am not a SQL Server DBA. We have SBS and I use SQL server to support
our intranet website that i created. I am not a database master by any
stretch of the imagination or even an intermediate dba. I simply know
some SQL, enough to get the job done. In our intranet there is not any
information that is critical if anyone sees it or if it is lost.

Now, though, I have been tasked with a task where i need to be
concerned a little bit with security. I have to get a file through
SFTP that is encrypted with a PGP key, decrypt it, and display its
contents to the customer service reps to enter orders. What I would
like to do is parse the file after it is decrypted and put the order in
a database, encrypting certain values from the file. How do I do the
encrypting part and I have to be able to decrypt it to display it when
the CSRs need to view it?

Thanks for any and all advice. Please understand that I am not a SQL
server pro and am on such a time crunch that I do not have the luxury
of becoming one for this project.

Thanks.

.

Relevant Pages

  • Re: SQL Server 2000 / 2005 Encryption
    ... to encrypt your SSL connections will be different. ... SQL Server can generate its own self-signed certificates though, and that should make the SSL encryption/connectivity easier for you. ... Excel does not know how to decrypt data stored in SQL Server 2005 in encrypted form. ...
    (microsoft.public.sqlserver.security)
  • Re: Encrypting & Decrypting
    ... > now i have learnt how to decrypt form google. ... >>Object encryption in sql server is really more object ... >>>>Mark Broadbent mcse+i, mcdba ...
    (microsoft.public.sqlserver.security)
  • Re: Oracle licence question
    ... general mistake rather than trying to bias the stats by making a general ... search on Oracle and a more selective one for SQL Server DBA. ... SQL Server - http://www.itjobswatch.co.uk/jobs/uk/sql%20server%20dba.do ... you should search 'ORACLE DBA' against 'SQL SERVER DBA' which is what I ...
    (comp.databases.oracle.server)
  • Re: managing application role passwords without hard-coding them into applications
    ... app, authenticating as the person, to select the password. ... internally decrypt the password then switch to the application role. ... > SQL Server database), for which only the application has ... > being hard coded into the app (ie preventing developers ...
    (microsoft.public.sqlserver.security)
  • Re: Decryption of SQL Server Login pwd
    ... You are not supposed to be able to decrypt it. ... Hal Berenson, SQL Server MVP ... True Mountain Group LLC ... "Hartono" wrote in message ...
    (microsoft.public.sqlserver.security)
Loading