SNOW-1866641: Allow giving targeted role ability to view AND share with snow streamlit share

[thomas-lochner]

Description

Currently the snow streamlit share command seems to only provide the targeted role with the ability to view an app. It would be helpful to be able to specify that the targeted role should also be able to share the app.

Context

There is no way to programmatically give a role share access for apps. We are using the cli to deploy any newly developed Streamlit apps on our team, and would like them to be automatically shared with a few of our roles, and give share access to each one of them. I have tried looking to see if there is also a GRANT USAGE TO FUTURE STREAMLITS IN DATABASE X command, but I don't believe this exists yet.