HomeSoftware Heritage

(MODULES-4158) Grant SELECT, UPDATE perms on sequences

Description

(MODULES-4158) Grant SELECT, UPDATE perms on sequences

Add support for granting SELECT and UPDATE permissions on sequences
(MODULES-4158).

This requires a significant change to the unless statement used to
determine whether the permission has already been granted. The previous
statement used the standard SQL information_schema tables, however these
provide limited information on sequence permissions. In order to retrieve
the current permission set with the necessary level of detail we must query
the pg_class system catalog and parse out the permisions from there.

Details

Provenance
Chris Reeves <chris.reeves@york.ac.uk>Authored on Nov 29 2016, 5:10 PM
olasdPushed on Mar 14 2017, 5:00 PM
Parents
rSPPG670298dafbab: Add more acceptance tests for grants on sequences
Branches
Unknown
Tags
Unknown

Event Timeline

Chris Reeves <chris.reeves@york.ac.uk> committed rSPPG35758e48e49b: (MODULES-4158) Grant SELECT, UPDATE perms on sequences (authored by Chris Reeves <chris.reeves@york.ac.uk>).Nov 29 2016, 5:35 PM