Skip to main content

Questions tagged [symmetric-key]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
5 views

pgp_sym_decrypt_bytea key error

I am trying to use a symmetric key to encrypt and decrypt a field in Postgres 14.10. I am encrypting per documentation like so: select pgp_sym_encrypt('data', 'password'); I am feeding the return of ...
kravb's user avatar
  • 179
1 vote
0 answers
64 views

OPEN SYMMETRIC KEY from AKV takes too long randomly

This post is similar to another question listed here. Encrypting data by OPEN SYMMETRIC KEY by ASYMMETRIC KEY created with Azure provider in SQL server takes more than 2 min We are also facing the ...
Imtiyaz Thange's user avatar
1 vote
2 answers
412 views

Decrypt Symmetrically/Asymmetrically Encrypted Data in MS SQL (T-SQL) Server via Apex Crypto Class

Hope you're having a good day. This is in continuation to my previously posted question in Salesforce StackExchange. I was suggested to seek help at DBA SE in order to find a way to extract Symmetric ...
Assadullah Shaikh's user avatar
1 vote
1 answer
257 views

What does a deterministic symmetric key mean?

In sqlservercentral blog I've encountered this phrase Symmetric keys are deterministic when created, meaning that the same parameters run in different databases will result in the same key. That ...
igelr's user avatar
  • 2,132
5 votes
2 answers
1k views

Changing a certifcate+key algorithm by dropping & recreating with the same names

We have a situation where a symmetric key has been created (a long time ago) using TRIPLE_DES. This is used to encrypt a password column, and is used by around ten stored procedures (that utilizes ...
EvilDr's user avatar
  • 850
5 votes
1 answer
810 views

Can I control which algorithm SQL Server uses to hash symmetric key passphrases

I will start by describing the issue / cause before asking my question: If you are using a symmetric key in SQL to encrypt data. This can be set up as follows: CREATE MASTER KEY ENCRYPTION BY ...
jasttim's user avatar
  • 163
1 vote
1 answer
475 views

How to stop decrypting data after opening master key in SQL Server?

I have implemented data encryption using SQL Server symmetric key encryption technique using a certificate, master key with password. When we backup database from PROD server and restore to a ...
Sri's user avatar
  • 393
1 vote
1 answer
359 views

What are implications for changing encryption from TRIPLE_DES to AES_128?

As title asks, what are implications for changing encryption from TRIPLE_DES to AES_128? I have an older database I've been tasked with hardening, and I need to updated the algorithm used for ...
proggrock's user avatar
  • 113
1 vote
1 answer
2k views

Recreate symmetric key of unknown CREATE SYMMETRIC KEY

I found that for each encryption of a symmetric key an entry in sys.key_encryptions is present and at least for ENCRYPTION BY CERTIFICATE-type entries I can use the certificate of the specified ...
TheConstructor's user avatar
0 votes
1 answer
2k views

How can we decrypt data knowing the symmetric key used for the encryption?

In this article is explained how to decrypt a symmetric key. For example: SELECT SK.name, SK.symmetric_key_id, SK.key_length, SK.algorithm_desc, KE.crypt_type_desc, COALESCE(C.name,AK....
gotqn's user avatar
  • 4,016
0 votes
1 answer
1k views

How to protect a symmetric key?

When a symmetric key is created we have the option to encrypted it by using at least one of the following: certificate, password, symmetric key, asymmetric key or EKM. When a password is used, it it ...
gotqn's user avatar
  • 4,016
4 votes
1 answer
1k views

Where does SQL Server store symmetric keys?

I am wondering if symmetric keys created in particular database are being stored in the primary file group? Or they are stored in some special file group which the user is not able to interact with? ...
gotqn's user avatar
  • 4,016
2 votes
1 answer
2k views

Creating Symmetric Key from external provider

Knowing the security objects hierarchy, we can see that in order to create a Symmetric Key and encrypt data, we need to create: Database Master Key which is protected by password Certificate which is ...
gotqn's user avatar
  • 4,016