439 reputation
718
bio website
location
age 36
visits member for 3 years, 3 months
seen Nov 11 at 10:17

* My Online C#5 spec — My colored clarified version.
* NG-print — Use it to print the angularjs documentation.
* Code Liner — Use it to paste code with line numbers to reference by you or by others.


Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
'using an account that has permission to query the data' you mean the SELECT * FROM sys.symmetric_keys query ?
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
Thank you very very very much. Eof.
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
@Rick If I used certificate , The hacker can see wheich certificates are installed , and by the code : OPEN SYMMETRIC KEY MySymetricKey DECRYPTION BY CERTIFICATE MyCertificate he can see the real data...
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
@Rick all day long ive been practicing on this page and therefor i had some conceptual questions...
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
but If I used certificate , The hacker can see wheich certificates are installed , and by the code : OPEN SYMMETRIC KEY MySymetricKey DECRYPTION BY CERTIFICATE MyCertificate he can see the real data...
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
I wish to thank you a lot. ( if i'll have more advanced sql question i'll ask you directly :) ) . thanks.
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
listen man you are awesome . question : for the code CREATE SYMMETRIC KEY SecureSymmetricKey WITH ALGORITHM = DESX ENCRYPTION BY PASSWORD = N'StrongPassword'; , is there any way by sql select command to see the N'StrongPassword' from SecureSymmetricKey ?
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
@Yahia , what about if hacker got my sql db into his hands (this is the scenario)...Is there any command that he would be able to find what is the passowrd which was used to encrypt ??
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
@Yahia : step by step : lets talk about 1) once the admin executed these lines. Is there any command that he would be able to find what is the passowrd which was used to encrypt ? ( cause a hacker can write : OPEN SYMMETRIC KEY SecureSymmetricKey DECRYPTION BY PASSWORD = N'StrongPassword'; and then see the data....
Oct
20
asked SYMMETRIC key & certificates role in sql server?
Oct
20
asked SQL Server symmetric key & certificates games by Hacker?