Let’s make sure you have postgresql db. Please follow your Postgres documentation for the installation. <\/p>\n\n\n\n
1) Create an admin user and grant superpuser (without superuser, you can do the alter ... owner\n\n2) alter to have the admin user owner\nalter schema public<\/strong> owner to administer;\n\n3)revoke the default create permissions\nrevoke create on schema public<\/strong> from<\/strong> public<\/strong>;\n\n4) revoke the public role's ability to connect to the database\nrevoke all on database demodb from public;\n\n5) create a write role and grant permissions\ncreate role db_write no login no inherit;\n\n-- grant usage on the db\n<\/em>grant usage on schema public to <\/strong>db_write;\n-- allow all operations on all tables\n<\/em>grant select<\/strong>, insert<\/strong>, update<\/strong>, delete on all tables in schema public to<\/strong> db_write;\n-- allow usage of sequences, need for serial keys etc\n<\/em>grant usage<\/strong>, select on all sequences in schema public to <\/strong>db_write;\n-- grant default operations on all tables created in the future\n<\/em>alter default privileges in schema public\n grant select<\/strong>, insert<\/strong>, update, delete on tables to <\/strong>db_write;\n-- grant default operations on all sequences created in the future\n<\/em>alter default privileges in schema public\n grant usage<\/strong>, select on sequences to <\/strong>db_write; \n\n5) create a user with the db_write role\ncreate role \"db_user\" with login in<\/strong> role db_write;\n\n6) grant user permission to connect to our database.\ngrant connect on<\/strong> database demodb to db_user;\n\n<\/pre>\n\n\n\nOnce you have a database setup, following steps to remove default public access<\/p>\n\n\n\n
If you do not have the db owner or if you need a new db owner, then create an admin user and grant superpuser (without superuser, you can do the alter ... owner\n\n1) alter to have the admin user owner\nalter schema public<\/strong> owner to administer;\n\n2)revoke the default create permissions\nrevoke create on schema public<\/strong> from<\/strong> public<\/strong>;\n\n3) revoke the public role's ability to connect to the database\nrevoke all on database demodb from public;<\/pre>\n