Mercurial > gemma
changeset 5331:5b2faff9ec81 extented-report
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,