The encryption tag has no wiki summary.
2
votes
1answer
25 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
43 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
71 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
66 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
53 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
83 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
126 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
158 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
90 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
189 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
207 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
103 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
400 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
377 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 ...
4
votes
1answer
1k views
How to use aes-encryption in PostgreSQL?
I tried aes-encryption by using following statement:
SELECT encrypt('test', 'key', 'aes');
which worked, but I am not able to decrypt the value. I inserted it in a field of datatype bytea but I'm ...
4
votes
1answer
181 views
Can you make SSL and SSL-only (hostssl) connections to PGPool?
The new version of PGPool (3.2) has an "SSL" section in the conf file, and directions on how to use it in the manual. However, pool_hba.conf specifically says that PGPool doesn't support SSL (i.e. ...
5
votes
2answers
423 views
When do I need to backup the Service Master Key?
I'm reading some documentation and whitepaper about Transparent Data Encryption. Some documentation mention to backup the Service Master Key as well (For clarification I'm not talking about the ...
0
votes
1answer
219 views
Two-way encryption in PostgreSQL version 9.1 database
What is the process of two-way encryption of data in PostgreSQL database version 9.1 using built-in functions?
3
votes
1answer
510 views
Implementing an encrypted table in SQL Azure
I'm moving an App to Azure and need to achieve PCI compliance for a couple columns in a single table. I realize I can encrypt the data before I store it, but I was wondering if there was a feature in ...
1
vote
1answer
59 views
Microsoft SQL Server 2008 encryption over multiple DB versions
I have about 5 clients deployed running different versions of MSSQL server 2008 (Some standard, some enterprise, ect) And I am being tasked with encrypting the data so:
The software we are using can ...
1
vote
0answers
162 views
Full Text Search with Encryption SQL Vs NoSQL? [closed]
Can any tell Which will be better for online and offline projects
2
votes
3answers
333 views
Which database is best for deeply embedded database or through C DLL?
I want a deeply embedded database. Deeply embedded means that the server is started by an application and closed by the application with no tcp/ip or 0 port. The main features of consideration are:
...
1
vote
1answer
233 views
Does replication with SSL encryption work on MySQL 5.5?
I am trying to set up replication with slave on Amazon EC2 and master in our local environment. The setup went fine without SSL encryption. But when I set up the replication to be SSL encrypted, it is ...
1
vote
1answer
146 views
Randomly generated password for mysql admin over time?
I have this idea of making my database's Admin account secured by creating the following:
Trigger is activated every hour in mysql this trigger activates a stored procedure
Stored procedure ...
3
votes
2answers
128 views
Microsoft SQL Server 2005 Encryption Options
I'm trying to explore some encryption options on Microsoft SQL Server 2005.
I've recently got around SQL Server 2008 and was able to enable Transparent Data Encryption (TDE). Now I'm trying to figure ...
4
votes
1answer
147 views
DB Master Key Encrypted By *Correct* Service Master Key?
My client has frequently run process where we move databases from a prod environment to lower environments (refresh QA with prod database, etc). These DBs have database master keys on them. We have ...
0
votes
1answer
121 views
What are the first necessary actions needed to help secure a database's schema & data? [closed]
This smells like an open-ended, opinionated, wiki free-for-all, but I'm not trying to make this a battle of opinions.
It seems like there should be a good checklist out there for all to agree on ...
1
vote
1answer
234 views
Storing Passport Numbers in a database
We're developing a travel/tourist application for a tours company who want to be able to input traveler information into an online database.
Is there any security best practice for storing passport ...
3
votes
2answers
1k views
MySQL encryption
I am thinking about encrypting some fields in MySQL database using MySQL's encryption functions. I can't find any good sources on how to properly implement it. Has anyone done this and have a good ...
1
vote
1answer
857 views
Simple Implementation of SQL Server 2008 Encryption
I am looking at using some of SQL Server 2008's encryption.
I have read the following article on MSDN:
http://msdn.microsoft.com/en-us/library/ms179331.aspx
Q1a: Is the master key password ...
4
votes
2answers
422 views
Cassandra encryption at rest
I need to store some sensitive data in Cassandra and require it to be encrypted at rest. Is it likely Cassandra would function normally on top of a Linux encrypted file system (something like the open ...
1
vote
1answer
239 views
Is it possible to fetch or update table data by table field type?
Is it possible to fetch or update table data by field type? If possible please tell me with a sample code.
1
vote
2answers
610 views
MySQL: How does AES_ENCRYPT turn the password into a key?
I am trying to figure out how to create the best secure password for AES_ENCRYPT. Specifically, how long should the password be, and how it translates into the 128 bit key length that AES typically ...
1
vote
2answers
2k views
How do you encrypt data while performing a mysqldump?
My OS is windows 7.
How can I encrypt data while performing a mysqldump?
From the command prompt, can I take a mysqldump with encrypted varchar and texts values?
Please help me.
Thanks
5
votes
3answers
1k views
Postgresql row-level encryption
Looking over the docs, I didn't see any mention of row-level encryption.
Lets assume I have a database of highly classified information that needs to get locked down. How can I implement a table with ...
2
votes
2answers
543 views
Is encrypted database possible?
I'm not a DBA but I've been asked to see if we can encrypt the data in sql server such that the admin, despite having access to SQL Server won't be able to see the data but application would still be ...
1
vote
1answer
3k views
tsql to find users and database level permissions mapped to a certificate
On SQL 2005 and above, how can I find users and database level permissions mapped to a certificate?
Story behing this:
I copied a database from SQL 2005 to SQL 2008. It had a certificate inside the ...
