Srinivasa varma varmad
varmad
/ rw_ro_access.sql
Created
February 14, 2020 12:22
— forked from checco/rw_ro_access.sql
How to create a read only user in AWS RDS PostgreSQL and a user with superuser privileges on AWS RDS PostgreSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Read only | |
| -- | |
| -- Create a group | |
| CREATE ROLE postgres_ro_group; | |
| -- Grant access to existing tables | |
| GRANT USAGE ON SCHEMA public TO postgres_ro_group; | |
| GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres_ro_group; |
varmad
/ install-ispconfig3-ubuntu.sh
Created
May 23, 2017 09:22
Install ISPConfig3 Ubuntu 16.04 64Bits
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| ## Install ISPConfig3 on Ubuntu 16.04 64Bits | |
| ## Author: Nilton OS www.linuxpro.com.br | |
| ## https://www.howtoforge.com/tutorial/perfect-server-ubuntu-16.04-with-apache-php-myqsl-pureftpd-bind-postfix-doveot-and-ispconfig/ | |
| ## Version 0.5 | |
| ## Set lang en_US UTF8 | |
| ## echo 'LC_ALL="en_US.utf8"' >>/etc/environment |