Mercurial > gemma

diff pkg/imports/sr.go @ 5314:0e8fd0e5bf36 zpg-exception

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sysadmins are also granted the ZPG exception if they are importing sounding data.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 16 Jun 2021 19:35:24 +0200
parents 1a565f8a935a
children 12a5e128255f
line wrap: on
line diff
--- a/pkg/imports/sr.go	Wed Jun 16 14:08:39 2021 +0200
+++ b/pkg/imports/sr.go	Wed Jun 16 19:35:24 2021 +0200
@@ -210,7 +210,8 @@
 `
 
 	selectZPGExceptionAllowedSQL = `
-SELECT country IN ('BG', 'RO') FROM users.list_users WHERE username = current_user`
+SELECT rolname = 'sys_admin' OR country IN ('BG', 'RO')
+FROM users.list_users WHERE username = current_user`
 
 	reprojectPointsSingleBeamSQL = `
 SELECT