Mercurial > gemma

changeset 5331:5b2faff9ec81 extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Create list_users view in the users schema.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 01 Jun 2021 00:22:33 +0200
parents bc8c082487b2
children 9df7b39297ed
files schema/updates/1450/01.report_reciever.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/updates/1450/01.report_reciever.sql	Sun May 30 19:53:04 2021 +0200
+++ b/schema/updates/1450/01.report_reciever.sql	Tue Jun 01 00:22:33 2021 +0200
@@ -1,7 +1,7 @@
 ALTER TABLE internal.user_profiles
   ADD COLUMN report_reciever boolean NOT NULL DEFAULT false;
 
-CREATE OR REPLACE VIEW list_users WITH (security_barrier) AS
+CREATE OR REPLACE VIEW users.list_users WITH (security_barrier) AS
     SELECT
         r.rolname,
         p.username,