Skip to content

Instantly share code, notes, and snippets.

@Tefnet
Tefnet / read-access.sql
Created June 20, 2018 08:55 — 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;
@Tefnet
Tefnet / ImageMagick.spec
Created August 22, 2019 12:39
ImageMagick 6.8.9-10 spec file for AmazonLinux
%global VERSION 6.8.9
%global Patchlevel 10
Name: ImageMagick
Version: %{VERSION}
Release: %{Patchlevel}
Summary: Use ImageMagick to convert, edit, or compose bitmap images in a variety of formats. In addition resize, rotate, shear, distort and transform images.
Group: Applications/Multimedia
License: http://www.imagemagick.org/script/license.php
Url: http://www.imagemagick.org/