Object Privileges

Upon setting up a project, certain privileges must be granted to the application to provide access to the source data. The individual privileges are shown below but are also referenced in the app when creating a new project (see project setup).

These database and schema level privileges must be granted for all source data:

GRANT USAGE ON DATABASE <database> TO APPLICATION SYNTHETIC DATA GENERATOR;

GRANT USAGE, MONITOR ON SCHEMA<database>.<schema> TO APPLICATION SYNTHETIC DATA GENERATOR;

Depending on the type of source object, you must also run the following grant statements for each object you would like to train using the app.

Tables:

GRANT REFERENCES, SELECT ON TABLE <database>.<schema>.<table> TO APPLICATION SYNTHETIC_DATA_GENERATOR;

Views:

GRANT SELECT ON VIEW<database>.<schema>.<view> TO APPLICATION SYNTHETIC_DATA_GENERATOR;

Tables:

GRANT SELECT ON MATERIALIZED VIEW <database>.<schema>.<materialized_view> TO APPLICATION SYNTHETIC_DATA_GENERATOR;

Tables:

GRANT SELECT ON DYNAMIC TABLE<database>.<schema>.<dynamic_table> TO APPLICATION SYNTHETIC_DATA_GENERATOR;

Tables:

GRANT SELECT ON ICEBERG TABLE <database>.<schema>.<iceberg_table> TO APPLICATION SYNTHETIC_DATA_GENERATOR;