BOBPORE.COM
BLOG —
AUG 26, 2020 · SYNDICATED FROM MEDIUM

I Altered My Redshift Schema's Default Privileges to Allow Access. Why Can't My Users Query My New Tables?

ALTER DEFAULT PRIVILEGES isn't applied at the schema level — it's applied at the schema-creator combination. The FOR USER clause is the fix.