Grant permissions on all existing objects

[camaya]

Hi,

Is there anywhere to grant permissions to a role to all existing objects on a schema with this provider? For instance, I'd like to execute something like this:

GRANT SELECT ON ALL TABLES IN SCHEMA public TO ROLE my_role;

The use case I've got right now is that I created a new role that has select permissions for future tables, but I need to grant it permissions on existing tables.

Cheers!