Postgres Model Schema Permissions

Toad Data Modeler
1 
In a Postgres model I've edited a given schema's properties, adding a particular user group on the "Permissions" tab.
However, I can't seem to locate how to get that to generate the expected SQL (e.g. GRANT ALL ON SCHEMA my_schema TO my_role;).

Any suggestions?

Thanks,
Pete
2

Hi Pete,

I’m sorry but it’s not possible to grant all of the available privileges at once. You must set both CREATE and USAGE privileges to schema to get the same result as GRANT ALL.

Regards,

David

3

Thanks for the reply, David. Understood, will do!

-Pete