createdb proormedent
createuser -e -E -l -P proormed


REVOKE ALL ON DATABASE proormedent FROM public;  -- shut out the general public
GRANT CONNECT ON DATABASE proormedent TO proormed;  -- since we revoked from public

GRANT USAGE ON SCHEMA public TO proormed;

GRANT ALL ON ALL TABLES IN SCHEMA public TO proormed;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO proormed; -- don't forget those

ALTER DEFAULT PRIVILEGES FOR ROLE proormed IN SCHEMA public
GRANT ALL ON TABLES TO proormed;