Create a new worksheet and run the following SQL commands. Replace these placeholders with your information: YOUR_DB, YOUR_SCHEMA, YOUR_STAGE, and APP_NAME.(To locate your app name, go to App Name).
Copy
Ask AI
GRANT USAGE ON DATABASE <YOUR_DB> TO APPLICATION "APP_NAME";GRANT USAGE ON SCHEMA <YOUR_DB>.<YOUR_SCHEMA> TO APPLICATION "APP_NAME";GRANT READ, WRITE ON STAGE <YOUR_DB>.<YOUR_SCHEMA>.<YOUR_STAGE> TO APPLICATION "APP_NAME";