Granting Object Privileges to Application

Only an account administrator with the 'ACCOUNTADMIN' role can grant privileges to the transfer app application to access tables outside of it's own database.

Below are example grants to allow the transfer app to load a leads table in a ta_verify database.

GRANT READ, WRITE ON STAGE ta_verify.test_uploads TO APPLICATION TRANSFER_APP;
GRANT USAGE ON DATABASE ta_verify TO APPLICATION TRANSFER_APP;
GRANT USAGE ON SCHEMA ta_verify.test TO APPLICATION TRANSFER_APP;
GRANT TRUNCATE, INSERT, SELECT, DELETE, UPDATE ON TABLE ta_verify.test.leads TO APPLICATION TRANSFER_APP;

Last updated