Toad World® Forums

Postgres Model Schema Permissions

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

 

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

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

-Pete