Support integration with non-root users for Cockroachdb's cert-manager

**Is your feature request related to a problem? Please describe.**
- Our application authenticates to cockroachdb cluster using client certificate
- We have disallowed authentication with root user for the app for better security
- Certificates for non-root user currently have to be manually created and rotated

**Describe the solution you'd like**
- Since there's already integration with cert-manager supported by cockroachdb, we'd like to enhance this and also include support for non-root users which I believe any app should ideally connect with

**Describe alternatives you've considered**
- A cronjob added to helm chart that would do automatic rotation of certificate using "cockroach" commands

**Additional context**
- None at this time

Jira issue: CRDB-35146