Feedback: CREATE USER

Jianwei Lin (lin-crl) commented:

Page: https://cockroachlabs.com/docs/v23.2/create-user.html

## What is the reason for your feedback?

[ ] Missing the information I need

[ ] Too complicated

[x] Out of date

[ ] Something is broken

[ ] Other

## Additional details
Please update the impact of setting password to NULL. Currently the doc says "To prevent a role from using [password authentication](https://www.cockroachlabs.com/docs/v23.2/authentication#client-authentication) and to mandate [certificate-based client authentication](https://www.cockroachlabs.com/docs/v23.2/authentication#client-authentication), [set the password as ](https://www.cockroachlabs.com/docs/v23.2/create-role#prevent-a-role-from-using-password-authentication)NULL."

However according [slack thread](https://cockroachlabs.slack.com/archives/C02FXN22FM0/p1713905488975989?thread_ts=1713498755.437199&cid=C02FXN22FM0)
"setting password to NULL will prevent password auth from working. if the customer does not create any client certs for that user, then cert authentication will not be possible either, so they'd have to use SSO"

Jira Issue: DOC-10154