|Configuring Security / Configuring User Authorization|
SQL exceptions are returned when errors occur with user authorizations.
GemFire XD validates the database properties when you set the properties. An exception is returned if you specify an invalid value when you set these properties.
After you set the gemfirexd.sql-authorization property to TRUE, you cannot set the property back to FALSE.
If a user attempts to connect to a distributed system but is not authorized to connect, SQLException 04501 is returned.
If a user with read-only access attempts to write to the system, SQLException 08004 - connection refused is returned.