Swapnil Man swapnilman

DevOps Engineer

swapnilman / gist:cccfbd6f4efc49b7cbc436583622e8f0

Last active April 2, 2024 10:35

Add user with read only access in Postgresql

	# Create a group
	CREATE ROLE readonly;

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

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

swapnilman / create-user.sh

Last active September 23, 2020 02:53

create user with root priilages

	echo "Note: Make sure to login as root user"
	echo "Username ?"
	read username
	adduser $username

	#Sudo Permission
	sed "/#\ User\ privilege\ specification/a$username\ ALL=(ALL:ALL)\ NOPASSWD:ALL" /etc/sudoers --in-place

	cd /home/$username

swapnilman / install-java.sh

Last active September 23, 2020 02:55

install Java 8 as default

	#!/bin/bash
	echo "Note: Login as root user"
	echo "installing java"

	mkdir -p /usr/local/java
	cd /usr/local/java

	curl -L -C - -b "oraclelicense=accept-securebackup-cookie" -O 'http://download.oracle.com/otn-pub/java/jdk/8u131-b11/d54c1d3a095b4ff2b6607d096fa80163/jdk-8u131-linux-x64.tar.gz'
	tar xvzf jdk-8u131-linux-x64.tar.gz

swapnilman / sql-schema-diff.sql

Last active September 23, 2020 02:57

compare two databases and lists out the differences

	SELECT B.* FROM (
	SELECT DISTINCT table_name FROM (
	SELECT table_name,column_name,ordinal_position,data_type,column_type,COUNT(1) match_count
	FROM information_schema.columns WHERE table_schema IN ('db1','db2')
	GROUP BY table_name,column_name,ordinal_position,data_type,column_type
	HAVING COUNT(1) = 1
	) AA
	) A INNER JOIN (
	SELECT table_schema,table_name,column_name,ordinal_position,data_type,column_type
	FROM information_schema.columns WHERE table_schema IN ('db1','db2')