The encryption tag has no wiki summary.
3
votes
1answer
34 views
SP with Encryption Read/Writes Stats
If a stored procedure in SQL Server 2005 is created with the syntax "WITH ENCRYPTION" ,are the reads and writes of the encrypted stored procedure recorded in the sys.dm_db_index_usage_stats? I am ...
1
vote
1answer
51 views
One call to `decryptbypassphrase` for decrypting all columns
If I use ENCRYPTBYPASSPHRASE to encrypt the full table then how can I decrypt full table easily by using DECRYPTBYPASSPHRASE?
Actually I have to use DECRYPTBYPASSPHRASE ('passphrase', column_name) ...
1
vote
0answers
74 views
SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB
I'm having a heck of a time with this issue and can't figure out what is wrong. I'm not sure how long this tiny DB has been in 'encryption_state = 2' from query:
SELECT * FROM ...
1
vote
1answer
55 views
SQL Server 2005 encryption - What Grants should I give
I use Mixed mode Authentication and I want my database users (in the Public role membership) to have the ability to JUST execute procedures that encrypt/decrypt data (using Certificate and Symmteric ...
2
votes
2answers
68 views
SQL Server 2005 encrypted database works on new PC without restore keys!
Something tells me that it was not normal.
Let me take it from the begining.
In an SQL Server Express 2005 I needed to encrypt one column. I did the following.
CREATE MASTER KEY ENCRYPTION
BY ...
0
votes
2answers
56 views
Changing passphrase for EncryptByPassPhrase
I am using EncryptByPassPhrase to encrypting some columns.
If I want to change the passphrase in the future, how can I change it?
3
votes
1answer
86 views
Database encryption and key management with pg_crypto
I am looking at the possibility of having to store root passwords for virtual machines in reversibly encrypted format in a database. The reason is that local logins will sometimes be required to ...
2
votes
1answer
128 views
Can I recover a TDE certificate by restoring the MASTER database?
(We are, fortunately, not currently in this situation, just planning ahead to see what our options would be if it ever occurred.)
For a database encrypted with Transparent Date Encryption (TDE), a ...
2
votes
1answer
159 views
Decryption not working when SQL Server database copied to new server
I am copying a database from an old server to a new server. The database has an encrypted column. From my searches I see that I need to backup the master key from the old server and restore it in ...
3
votes
2answers
97 views
Verifying Oracle*Net network encryption
I've been struggling to implement Oracle's network encryption between two of my test boxes. I think I've finally been able to do it, but I can't seem to find a way to verify that it is indeed ...
0
votes
1answer
191 views
Stored procedure encryption and master service master key, SQL Server 2008
Is the Service Master Key (SMK) used to encrypt stored procedures in SQL Server 2008?
I know it is used for data, but what about database objects? If the Service Master Key is not used, then I would ...
1
vote
1answer
219 views
How to properly secure MySQL database?
We have a web application based on the famous triad apache + php + mysql which we sell to our customers and gets installed on their servers.
Currently, we are using MySQL 5.1.41 which has only a ...
2
votes
1answer
107 views
Best patterns for encrypting database columns/tables in SQL Azure
Azure SQL doesn't support many of the encryption features found in SQL Server (Table and Column encryption). We need to store some sensitive information that needs to be encrypted and we've rolled our ...
1
vote
3answers
413 views
Encrypt/Decrypt output & input for SSIS task
I use SSIS packages to output the data from one system as Comma Separated Values, and then import that same data into a second system. I have a new requirement to encrypt the CSV text files that are ...
2
votes
2answers
383 views
Encrypt MySQL database on a Linux VPS?
I'm working on a rails app for our church, which stores some fairly sensitive information about our people in a MySQL database.
We have our own windows server running Hyper-V so the original ...
