See also:
| Service | Type | RAM | Storage | Limitations |
|---|---|---|---|---|
| 👉 Adaptable | PaaS | 256 MB | Non-persistent? (1 GB database storage available) | |
| AWS EC2 | IaaS | 1 GB |
| #!/bin/bash | |
| folders='Compressed Documents Images Music Programs Videos' | |
| ext_comp="*.zip *.tar.gz *.tgz *.rar *.7z" | |
| ext_doc="*.htm* *.php *.txt *.css *.doc* *.pdf *.PDF *.ppt* *.js *.csv" | |
| ext_font="*.ttf" | |
| ext_img="*.jp*g *.JPG *.png *.gif" | |
| ext_music="*.mp3 *.aac *.wma" | |
| ext_progrm="*.deb *.exe *.run *.sh" | |
| ext_vid="*.mp4 *.mkv *.flv *.avi *.webm *.wmv" |
| -- 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; |