Privileges in Omnata are granted via Snowflake roles.
From Snowflake blog:
When a provider publishes an application, it includes a manifest file. This manifest contains the permissions to be granted to the application, which can be reviewed by the application consumer during installation. By default, a Snowflake Native App has no permissions outside of the application itself, including data access or the ability to create database objects (tables, tasks, warehouses, etc).
Additional rights can be granted to the application, but that must be done by the application consumer administrators through explicit grants or references. Application code runs as a new application role, with owner’s rights, such that it can only access what that role has been granted to do. This means that the application can’t access data that the caller has access to—it must be explicitly granted permission.
If you would like to grant access to Omnata owned objects to other roles, you grant the OMNATA_ADMINISTRATOR role to the other roles.
Run the command:
grant application role OMNATA_SYNC_ENGINE.OMNATA_ADMINISTRATOR to role MY_OTHER_ROLEBy default, Omnata lands data in the Omnata Sync Engine database. Refer to Inbound Storage Location for more information on how this can be customized.
Last updated