No announcements
Found 1023076 threads
-
0 Votes(password + symmetric key)
When using the SYMMETRIC KEY protected by a password, the password is required but not sufficient to access the data, permission on the SYMMETRIC ...Answered | 1 Replies | 5851 Views | Created by edm2 - Thursday, March 19, 2009 11:26 PM | Last reply by Raul Garcia - MS - Friday, March 20, 2009 1:53 AM
-
0 Votes
Cant open symmetric key
As per my understanding , at a time only one session can access data from an opened symmetry key .Answered | 1 Replies | 5971 Views | Created by nsp_ - Thursday, November 12, 2009 1:24 AM | Last reply by Lekss - Thursday, November 12, 2009 2:38 AM -
0 Votes
Symmetric Key
The database owner as full permission on all objects inside the owned database, hence the documented restrictions.Answered | 4 Replies | 916 Views | Created by sakurai_db - Monday, March 10, 2014 4:18 AM | Last reply by Dan Guzman - Monday, March 10, 2014 11:17 AM -
0 Votes
Symmetric Key Issue
Hi ClaytonHoyt, In your scenario, as you are coping the symmetric key from another report server, and symmetric key is not the same one that ...Answered | 1 Replies | 797 Views | Created by ClaytonHoyt - Thursday, March 10, 2016 3:35 PM | Last reply by Qiuyun Yu - Friday, March 11, 2016 5:16 AM -
2 Votes
Database restore & Symmetric keys
That should be all that you need in order to access the encrypted data.Answered | 4 Replies | 12661 Views | Created by york0001 - Thursday, November 19, 2009 3:04 PM | Last reply by Raul Garcia - MS - Thursday, November 19, 2009 7:31 PM -
0 Votes
SQL SERVER SYMMETRIC KEY SECURITY ISSUE
Hi conqueredplanet, Instead of making the symmetric key be encrypted by a certificate which is in turn encrypted by the database master ...Answered | 2 Replies | 965 Views | Created by conqueredplanet - Thursday, May 28, 2015 8:38 AM | Last reply by Lydia Zhang - Monday, June 1, 2015 2:44 AM -
7 Votes
SQL Symmetric key backup
Hello Sam, You're correct, there is no T-SQL command to backup a single symmetric key (unless you count the service master key and the database ...Answered | 6 Replies | 15747 Views | Created by Samagra - Thursday, November 8, 2012 1:04 PM | Last reply by Thiruveedhula - Friday, May 3, 2019 4:54 PM -
2 Votes
List/show users that have access to symmetric keys SQL 2005
You should be able to run this query to see the information that you are after: select u.name, p.permission_name, p.class_desc, object_name(p.major_id) ObjectName, ...Answered | 2 Replies | 10129 Views | Created by steve.schneider - Wednesday, April 7, 2010 6:09 PM | Last reply by steve.schneider - Thursday, April 8, 2010 11:37 AM -
2 Votes
ENCRYPTBYKEY, CERTIFICATES, SYMMETRIC KEYS
plaintext-vs-cleartext What do Symmetric Keys and Asymmetric Keys do?Answered | 2 Replies | 1197 Views | Created by paoloam.roxas - Friday, April 24, 2020 10:33 AM | Last reply by Dawn Young - Monday, April 27, 2020 5:57 AM -
0 Votes
consequence of not calling CLOSE SYMMETRIC KEY
Hi MSDN Student, Open symmetric keys are bound to the session not to the security context.Answered | 1 Replies | 2242 Views | Created by MSDN Student - Tuesday, September 18, 2012 5:10 PM | Last reply by Maggie Luo - Wednesday, September 19, 2012 10:15 AM -
0 Votes
Creating a Symmetric key
You are specifying the wrong key name to the KEY_GUID function ('textsymmetrickey' instead of 'testsymmetrickey').Answered | 3 Replies | 2646 Views | Created by DavidFast - Saturday, May 5, 2012 3:56 PM | Last reply by DavidFast - Saturday, May 5, 2012 4:13 PM -
1 Votes
Error- The report server cannot decrypt the symmetric key.
System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database.Answered | 2 Replies | 14221 Views | Created by Govardhan TB - Tuesday, August 25, 2009 3:43 AM | Last reply by Prasanna K J - Tuesday, August 25, 2009 5:13 AM -
1 Votes
Recovering the symmetric key from the Keys table
If you don't have a backup of your encryption keys you will not be able to recover/restore the key, that is why its always a good practice to backup your encryption keys as ...Answered | 2 Replies | 1578 Views | Created by Amazing Barry - Wednesday, July 29, 2015 11:14 PM | Last reply by Amazing Barry - Thursday, July 30, 2015 1:53 PM -
0 Votes
Symmetric Key GRANT REFERENCES or GRANT VIEW DEFINITION
Hi Amy, Based on my test, these two permission seem to be the same.Answered | 2 Replies | 7701 Views | Created by Amy2006 - Wednesday, June 23, 2010 2:27 PM | Last reply by Raul Garcia - MS - Friday, June 25, 2010 7:45 PM -
0 Votes
moving certificate and symmetric keys between servers
After granting permission on Certificate and Symmetric key to users, it works.Answered | 6 Replies | 3651 Views | Created by new SQLServer user - Friday, November 8, 2013 6:38 PM | Last reply by Sean Gallardy - Monday, February 17, 2020 2:32 PM -
0 Votes
Similiarity of values in Symmetric key encryption
When using EncryptByKey builtin, teh function will prepend the key GUID as part of the ciphertext message.Answered | 1 Replies | 5913 Views | Created by edm2 - Friday, March 20, 2009 12:05 AM | Last reply by Raul Garcia - MS - Friday, March 20, 2009 1:48 AM -
1 Votes
Symmetric key password length problem...
> establish a symmetric key on the target server * It may help if you post the exact procedure (the query that you use - which options used during the ...Answered | 1 Replies | 911 Views | Created by Doombar - Friday, October 27, 2017 9:10 AM | Last reply by pituach - Saturday, October 28, 2017 5:55 PM -
1 Votes
SYMMETRIC key encrypt the integer value?
Hi I am using sql server 2005, I want to encrypt data and i am using Symmetric key.Answered | 2 Replies | 13795 Views | Created by AsitSinha - Thursday, May 29, 2008 12:05 PM | Last reply by Ed Price - MSFT - Sunday, January 8, 2012 6:33 AM -
0 Votes
Any query closes my symmetric key
The key returns at the 101th query (and, I suppose, every 100th query).Answered | 5 Replies | 3507 Views | Created by yecril - Thursday, August 23, 2012 9:34 AM | Last reply by yecril - Friday, August 24, 2012 8:53 AM -
0 Votes
Problem Opening Symmetric Key with passed "password"
It's very natural to invoke "Open key" in a stored proc, passing in the Passphrase as a parameter.Answered | 5 Replies | 8168 Views | Created by edm2 - Thursday, November 5, 2009 5:07 AM | Last reply by Alex Feng (SQL) - Monday, November 16, 2009 9:50 AM - Items 1 to 20 of 1023076 Next ›
No announcements
