wangmengyu

#!/bin/bash
set -euo pipefail

function myFunction() {
	myCommand
	return $?
}

retry=0
maxRetries=5

wangmengyu

-- 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;