1 Answer
- Newest
- Most votes
- Most comments
0
Make sure you are logging on to database in QEv2 using Federated user for authentication. If still you cannot see the objects then try grant usage on <schema_name> to "IAMR:<role_name>";
Once a materialized view is created then it becomes a local object in Redshift and the data is now stored in Redshift. You can control access to it as if its a table using standard GRANT statements.
answered 8 months ago
Relevant content
- asked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago