Set the SQL Standard Authorization Mode

Use the gemfirexd.sql-authorization property to enable GemFire XD standard authorization.

The gemfirexd.sql-authorization property controls the ability for object owners to grant and revoke permission for users to perform actions on database objects that they create.

The valid settings for the gemfirexd.sql-authorization property are: The default setting for the gemfirexd.sql-authorization property is FALSE.

After you set the gemfirexd.sql-authorization property to TRUE, you cannot set the property back to FALSE.

When you enable this property, all new database schemas have SQL authorization enabled.

To enable SQL standard authorization for the entire system, set the gemfirexd.sql-authorization property as a system property. For example, add this line to gemfirexd.properties:
gemfirexd.sql-authorization=true