10 июл. 2019 г. · I want to create database users who can only query and see certain views created specifically for them in Redshift. I have example code below ...

3 янв. 2020 г. · Create a new role to own the view, then grant that role to any users who need permission to refresh the view.

3 февр. 2022 г. · I have a materialized view that needs refreshed as part of my ETL pipeline. The ETL pipeline is ran by an ETL user. I am getting the following ...

26 июл. 2019 г. · I have created a view in schema2 from table in schema1. Now i have granted access to the group for schema2 but they are not able to access the view.

21 февр. 2023 г. · I have designed a schema for my data flow where one MV depends on another. When I run the CREATE statements as a superuser, everything works fine.

9 дек. 2023 г. · Permissions on the tables, functions and other objects used in a view are checked for the owner of the view, not the user who uses the view.

11 сент. 2013 г. · I'd like to view grants on redshifts. I found this view for postgres: CREATE OR REPLACE VIEW view_all_grants AS SELECT use.usename as subject, nsp.nspname as ...

16 нояб. 2021 г. · There's a stored procedure which is executed every morning to run the 'REFRESH MATERIALIZED VIEW..' command after the daily ETL process.

24 нояб. 2020 г. · You can only GRANT or REVOKE the USAGE permission on an external schema to database users and user groups that use the ON SCHEMA syntax.

2 февр. 2022 г. · I get this error my when i'm selecting from an mview i created. select * from mview_age_stats This mview definition is using an external schema in its ...