Questions tagged [cryptography]
The cryptography tag has no usage guidance.
13
questions
1
vote
1
answer
45
views
Download certificate from Key Vault w/ private key for use in SQL Server (TDE) via powershell
I need to download an x509 Certificate from Azure Key Vault and import it in SQL Server to use for TDE.
Note: I'm not referring to EKM providers/ASYMMETRIC KEYs, where SQL accesses key vault to pull ...
- 2,073
0
votes
1
answer
33
views
(PostgreSQL pgcrypto) How to generate blowfish hash without salt?
In PostgreSQL, using the pgcrypto module, I can generate a slow hash with blowfish (or any supported algorithm) like this:
crypt('SomeTextHere', gen_salt('bf'));
However, it auto-generates a salt (...
1
vote
2
answers
325
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 ...
0
votes
0
answers
77
views
External verification of `SIGNBYCERT()` signatures from SQL Server 2016
I want to sign plaintext using a SQL Server certificate and then verify that signature using the certificate's public key on an external system. Here's what I've tried.
-- Create a self-signed ...
- 765
1
vote
0
answers
243
views
Postgres: Encrypted User Function. Is it possible?
is it possible to create a function on PostgreSQL server, which routines can't be seen by any Postgres-user on the server?
The function gets some string as a parameter and outputs a boolean value. ...
- 11
1
vote
0
answers
547
views
Informatica MD5 function vs SQL Hashbytes MD5 function
I am hoping someone has some crossover experience here. I am attempting to utilize the Hashbytes function within SQL to match a value that is being generated utilizing the MD5 function from ...
- 111
1
vote
0
answers
556
views
Encrypt through Java and Decrypt through SQL Server AES 256
Am trying to insert some value through JAVA Application with AES Algorithm and need to decrypt the data from the SQL Procedure and need to process a data.
Which is the best practice to do so?
- 21
3
votes
2
answers
258
views
Detect if `pg_crypto` in Postgres was built with strong random feature enabled
The source code for pg_crypto module mentions an option to build without cryptographically-strong random generation.
/*
Generate random bits. pg_backend_random() will do here, we don't promis
UUIDs ...
- 10.6k
4
votes
1
answer
406
views
Encrypt data with DES_CBC_PKCS5 in DB2
I am using encryption algo DES/CBC/PKCS5Padding. How do I encrypt data using this in DB2?
In Pl/SQL I used DBMS_CRYPTO package with DES_CBC_PKCS5 from DBMS_CRYPTO Block Cipher Suites - https://docs....
- 167
4
votes
3
answers
2k
views
PGP for securing my database?
I have considered TDE and cell level encryption mechanism for securing my database, however these two cannot fully satisfy my requirements.
I've found that PGP may help me, but it is mainly used for ...
- 557
7
votes
3
answers
6k
views
Adding unsigned 256 bit integers in PostgreSQL
I was wondering if there would be any way to do the following in PostgreSQL:
UPDATE cryptotable SET work = work + 'some big hexadecimal number'
where work is an unsigned 256 bit number. Right now my ...
- 347
5
votes
1
answer
121
views
How is SQL Server host identity ensured?
When I connect to some e-commerce website with my browser I use HTTPS that uses a certificate that (more or less) guarantees that example.com is indeed example.com.
Now I connect to a SQL Server ...
- 1,301
17
votes
3
answers
8k
views
Securely generate a UNIQUEIDENTIFIER in SQL Server
I intend to be using a UNIQUEIDENTIFIER as an access key that users can use to access certain data. The key will act as a password in that sense.
I need to generate multiple such identifiers as part ...
- 7,310