sundeck-io / OpsCenter

OpsCenter for Snowflake makes it easy to understand and manage your Snowflake consumption

Other

25 stars 15 forks source link

Grant Create Warehouse Role to Native App #666

Closed anshuldata closed 6 months ago

anshuldata commented 6 months ago

Pull Request Template

Description

Grant Create Warehouse role to App.
No extra privilege needs to be given for drop. It is because creator gets an ownership on object

Checklist:

[x] I have verified that my change is functionally correct (unit tests are great).
[x] Queries against newly-added, user-facing objects can be expected to complete in 1's of seconds.
[x] My change will not have a substantial increase the user's cost to have the app installed (did you add any new tasks?).

anshuldata commented 6 months ago

App deploy is failing with File: 001_schemas_and_roles.sql [Uncaught exception of type 'STATEMENT_ERROR' on line 39 at position 0 : Grant not executed: Insufficient privileges.] was primary error.

I think we have to ask permission from user similar to manage warehouse (here). Is it correct understanding @rymurr ?

pravindra commented 6 months ago

I think we have to ask permission from user similar to manage warehouse (here). Is it correct understanding @rymurr ?

yes.