Set the SQL Standard Authorization Mode

Use the sqlfire.sql-authorization property to enable SQLFire standard authorization.

The sqlfire.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 sqlfire.sql-authorization property are:
The default setting for the sqlfire.sql-authorization property is FALSE.

After you set the sqlfire.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 sqlfire.sql-authorization property as a system property. For example, add this line to sqlfire.properties:
sqlfire.sql-authorization=true