Product Documentation

Appearance

SHOW SSL TRUST ​

Validate the results of the IMPORT SSL TRUST command.

SHOW SSL TRUST

Non-superusers must have sysadmin (or consumeradmin) membership in order to run SSL trust commands.

For example:

premdb=# show ssl trust;
-[ RECORD 1 ]----------------------------------------------------------------------------------------------------
hash        | 2c5c660b.0
details     | notBefore=Dec 13 18:25:37 2019 GMT                                                                 +
           | notAfter=Dec 12 18:25:37 2029 GMT                                                                  +
           | issuer= /C=US/ST=CA/O=Yellowbrick Data, Inc./OU=a993ad4e-446d-4e66-90ac-ca1bd369e4e2/CN=sys_ybd_ca +
           | subject= /C=US/ST=CA/O=Yellowbrick Data, Inc./OU=a993ad4e-446d-4e66-90ac-ca1bd369e4e2/CN=sys_ybd_ca+
           | serial=935FE78414FCA7EC                                                                            +
           | 
certificate | -----BEGIN CERTIFICATE-----                                                                        +
           | MIIF3jCCA8agAwIBAgIJAJNf54QU/KfsMA0GCSqGSIb3DQEBCwUAMH8xCzAJBgNV                                   +
           | BAYTAlVTMQswCQYDVQQIDAJDQTEfMB0GA1UECgwWWWVsbG93YnJpY2sgRGF0YSwg                                   +
           | SW5jLjEtMCsGA1UECwwkYTk5M2FkNGUtNDQ2ZC00ZTY2LTkwYWMtY2ExYmQzNjll                                   +
           | NGUyMRMwEQYDVQQDDApzeXNfeWJkX2NhMB4XDTE5MTIxMzE4MjUzN1oXDTI5MTIx                                   +
           | MjE4MjUzN1owfzELMAkGA1UEBhMCVVMxCzAJBgNVBAgMAkNBMR8wHQYDVQQKDBZZ                                   +
           | ZWxsb3dicmljayBEYXRhLCBJbmMuMS0wKwYDVQQLDCRhOTkzYWQ0ZS00NDZkLTRl                                   +
           | NjYtOTBhYy1jYTFiZDM2OWU0ZTIxEzARBgNVBAMMCnN5c195YmRfY2EwggIiMA0G                                   +
           | CSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC+rCGJSoJ+nhV4EJqXyMzW8EWIPR+N                                   +
           | 1Y0Heru27NH1WSPpQWu7qjKVXkegQBeA1R4pZwNVFFEvrZ6fSmNxN/F80POJMA9F                                   +
           | eVUBHJAri7cJqENyaJ5qt8rYsdL4OFBEQ4uy8pxW8wcNuFjiX9E2l4oroe7ZhTBC                                   +
           | Tm6n344xjiUvBjvNAiE7TGJIX5jsiWybQykL2Ah+1+PkgOyHrupANe99T11z5ian                                   +
           | jrn9BImuwwD5LYTwMbvCUqTcOcGgotsEGVcFQvKJ5dh1ASCkXfw7RkaX1+mZQO3b                                   +
           | gj+reHvZAdlY9jbCLVpjCxN+mbEvYNE0FHHos9pobQktD6FXbRlTkSlgEhEzK8qb                                   +
           | OFgUN/N6V5UeqSZTWkSvhRh8Bw+MlYAVzkYvwnKqCLShMZRNXjQrfiRWf25XV1t+                                   +
           | Cq4lfusvJJ89B1jlTwbn5u6mBxkoxYPe0s3iXtCkK6HRMm3uH9kwpBaHTExc2D8V                                   +
           | BLUrnRBWYJaYh7Zec2je24l8KjJNH/d7ZOwEieiU1TT/N+5Hp/6pi8Gl171chfSj                                   +
           | eIS0+eTfu5HFH7VR4pJvkzCFilnfpZhejtFOqMQxkOauXas+M9Q3wbc16BDje31D                                   +
           | dodK3K9JThzn1AOekrvFy1Oc3uVofKkclfb9kyO+lulK3uIZpC3SHjW+xjYHPQbn                                   +
           | EAiSNXVopdPrWwIDAQABo10wWzAMBgNVHRMEBTADAQH/MAsGA1UdDwQEAwIB5jAd                                   +
           | BgNVHQ4EFgQUckz3dAaFdjZ9MBK/Z8FWGoBgo0QwHwYDVR0jBBgwFoAUckz3dAaF                                   +
           | djZ9MBK/Z8FWGoBgo0QwDQYJKoZIhvcNAQELBQADggIBAJ+1b22CfNldfZZQCKl5                                   +
           | 6Yt7rr5YZ7klwjITG6OX1TOJCjfnOe8zeMnOcOjtzWiiRGFluiDyLJPBRxpOwr42                                   +
           | PtBOREpGIwp7djbKxIcco03wgA2bm/t63vMQi1YJ3uBLKuqSgm1+yV9eMYABy4fG                                   +
           | mTcWkKx8D+RWhIboIHnADq3A3u6Ws1s2qq/vT/Mln8AplB3si93JRUqJXVLLi+RO                                   +
           | iD1tI8p4+Dthq6Dym9KFhBWdZwSVNBJdV9PGq1AZwMtk3w2aByzvc67B0LqveHKY                                   +
           | uIZpO0PPVd6er6uzxO2U5hx4IJe3fLFk8R4j0Ckbds27Jv5ZPSDGgA05QLKdEXzJ                                   +
           | /kAr01612BLQYdAv0Jvom99AFV7MdNppn2AexRenGYF5aQ3Ec4nxsREO29J4ttEp                                   +
           | P5Kh4eN707QIBn27ZtngUEcwHCWr527aRCdTLpqn06OVZ2Plynf0yLmrhO9glyVV                                   +
           | 7P97Jpu08Zx5Osn9z2ZQ/jUEdMGklt6UDeACQfKo7XLiO1w53oQjrnTfWtRZIYdg                                   +
           | wcp+KQqinONXYWtVBpDnHJ4R7+tMne9kJqHTMmiyrCceFNBoE6AiKtXaKZPyynFi                                   +
           | kqU7fQQDu8pHwRFXfnxJQ5ATzjnXDaNnAByU+IPPaHjJPmDYEpue6efrqEolSsdV                                   +
           | 3rhJxLSKZeIKIbS5m3zRbcoH                                                                           +
           | -----END CERTIFICATE-----                                                                          +
           |

Parent topic:SQL Commands