1. Connect to the postgres DB. 2. Run the following SQL:
create database test_database;
3. Run the following SQL:
create role my_group;
4. Connect to the test_database DB. 5. Run the following SQL:
alter default privileges in schema public grant all on types to my_group;
6. Open pgAdmin III. 7. Navigate to the public schema in test_database. 8. Right-click the public schema and choose Properties. 9. Select the Default Privileges tab. 10. Note that all four subtabs are empty, and the Role drop-down lists do not list my_group as a role.