February 19, 2015 at 8:33 pm
Comments posted to this topic are about the item Signing options
February 19, 2015 at 11:17 pm
Thank you Steve, really good one.
(As we opt to learn new things each day- selecting an option via mobile browser in a moving and shaking vehicle is not at all easy; even though knowing the answer, ended up clicking the wrong one. :hehe:)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 19, 2015 at 11:39 pm
..
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 20, 2015 at 1:41 am
ADD [ COUNTER ] SIGNATURE TO module_class::module_name
BY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
| CERTIFICATE cert_name [ WITH PASSWORD = 'password' ]
| CERTIFICATE cert_name WITH SIGNATURE = signed_blob
| ASYMMETRIC KEY Asym_Key_Name
| ASYMMETRIC KEY Asym_Key_Name [b] WITH PASSWORD = 'password'.[/b]
| ASYMMETRIC KEY Asym_Key_Name WITH SIGNATURE = signed_blob
February 20, 2015 at 2:26 am
Great question, thanks Steve.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 20, 2015 at 2:27 am
Carlo Romagnano (2/20/2015)
ADD [ COUNTER ] SIGNATURE TO module_class::module_nameBY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
| CERTIFICATE cert_name [ WITH PASSWORD = 'password' ]
| CERTIFICATE cert_name WITH SIGNATURE = signed_blob
| ASYMMETRIC KEY Asym_Key_Name
| ASYMMETRIC KEY Asym_Key_Name [b] WITH PASSWORD = 'password'.[/b]
| ASYMMETRIC KEY Asym_Key_Name WITH SIGNATURE = signed_blob
Yes, and?
You are still using an asymmetric key or a certificate.
You cannot sign a stored procedure with a password alone.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 20, 2015 at 3:18 am
Koen Verbeeck (2/20/2015)
Carlo Romagnano (2/20/2015)
ADD [ COUNTER ] SIGNATURE TO module_class::module_nameBY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
| CERTIFICATE cert_name [ WITH PASSWORD = 'password' ]
| CERTIFICATE cert_name WITH SIGNATURE = signed_blob
| ASYMMETRIC KEY Asym_Key_Name
| ASYMMETRIC KEY Asym_Key_Name [b] WITH PASSWORD = 'password'.[/b]
| ASYMMETRIC KEY Asym_Key_Name WITH SIGNATURE = signed_blob
Yes, and?
You are still using an asymmetric key or a certificate.
You cannot sign a stored procedure with a password alone.
OK!
Thanks!
February 20, 2015 at 5:08 am
This was removed by the editor as SPAM
February 20, 2015 at 6:09 am
Nice question. I learned something new from this, so thank you.
February 20, 2015 at 10:19 am
I remember hearing about using certs in passing conversation. Nice to see it again and learn more about it.
Good question...
Not all gray hairs are Dinosaurs!
February 20, 2015 at 1:02 pm
+1 helps to have done this a couple times. Great question.
Andre Ranieri
February 21, 2015 at 11:08 pm
Ok, got it wrong, but @ least learned somthing new 2day, thanx.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
February 23, 2015 at 4:22 am
In the daily newsletter email I recieved, the answer for that question was: "You can use certificates, asymmetric keys, or passwords" while the answer on the website is: "You can use certificates or asymmetric keys only"!
Which is right? and which is wrong?!
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
February 23, 2015 at 12:48 pm
I think I've seen this question before. Thanks for the reminder.
February 24, 2015 at 10:21 am
Hany Helmy (2/23/2015)
In the daily newsletter email I recieved, the answer for that question was: "You can use certificates, asymmetric keys, or passwords" while the answer on the website is: "You can use certificates or asymmetric keys only"!Which is right? and which is wrong?!
We corrected the question after the next newsletter was set.
You can only use keys. The password included in the options is for the key access, not the procedure signing.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply