Signing options

  • Comments posted to this topic are about the item Signing options

  • 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.

  • ..

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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

  • 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

  • Carlo Romagnano (2/20/2015)


    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

    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

  • Koen Verbeeck (2/20/2015)


    Carlo Romagnano (2/20/2015)


    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

    Yes, and?

    You are still using an asymmetric key or a certificate.

    You cannot sign a stored procedure with a password alone.

    OK!

    Thanks!

  • This was removed by the editor as SPAM

  • Nice question. I learned something new from this, so thank you.

  • 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!

  • +1 helps to have done this a couple times. Great question.

    Andre Ranieri

  • Ok, got it wrong, but @ least learned somthing new 2day, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • 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

  • I think I've seen this question before. Thanks for the reminder.

  • 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