Harikrishnan B haribinp

Account for InApp

haribinp / read-access.sql

Created February 15, 2023 05:13 — forked from oinopion/read-access.sql

How to create read only user in PostgreSQL

	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	-- Grant access to future tables
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

haribinp / Nginx Simple Proxy Pass Configuration

Created February 2, 2023 06:49

	upstream django_app {
	server 127.0.0.1:8000;
	}

	server {

	listen 80;
	server_name demo.gatos.io;

	access_log /var/log/nginx/app.log;