Users and roles are managed via Kibana Stack Management or /_security/user — not exposed through Elasticsearch SQL JDBC.
/_security/user