Redshift Permissions Example Code Update

[nicolesmith24]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/reference/database-permissions/redshift-permissions

What part(s) of the page would you like to see updated?

The first command shown grant usage on database database_name to user_name; is not accurate. You cannot grant usage on a database, but you can on a schema.

Instead of USAGE you would want to use CONNECT grant connect on database database_name to user_or_group

Additional information

No response

[mirnawong1]

thank so much for raising this @nicolesmith24 ! i'll get this looked at on our end ✨

[mirnawong1]

hey @nicolesmith24 ! we've created a pr to address this. you're absolutely right that there's no agrant usage on databasea ... in Redshift. however, there's also no agrant connect on databasea ... either since that's a Postgres thing. i've removed the line altogether now.