Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Expose public_key of Certificate in sys.certificates, just like sys.asymmetric_keys is doing

Please expose the public key of each Certificate via a "public_key" field in the sys.certificates system catalog view ( https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-certificates-transact-sql ).

This is currently available for Asymmetric Keys in the sys.asymmetric_keys ( https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-asymmetric-keys-transact-sql ) catalog view, and it should likewise be available for Certificates. I cannot think of a reason to not expose this since it is the "public" key, and by its very nature, is meant to be exposed.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Solomon Rutzky shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base