Local Users

Local users authenticate using credentials stored directly within the CData Virtuality Server, without involving any external identity providers. You can manage this authentication method using the SET statement as described below.

SET PASSWORD

This statement allows to change connection credentials, but does not perform a re-authentication:

SET PASSWORD 'someval';;

SET SESSION AUTHORIZATION

This statement performs a re-authentication given the credentials currently set on the connection:

SET SESSION AUTHORIZATION 'newuser';;