This works now: GRANT ALL ON DATABASE yourdatabase TO ROLE yourrole;