Merge branch '124-grant-activity' into 'master'

agneum · agneum · commit e01f970c8bec · 2021-02-11T07:04:38.000Z
fix: grant permissions on pg_stat_activity (#joe124) Closes #124 See merge request postgres-ai/database-lab!262
diff --git a/pkg/services/provision/databases/postgres/postgres_mgmt.go b/pkg/services/provision/databases/postgres/postgres_mgmt.go
@@ -206,6 +206,8 @@ begin
       new_owner
     );
   end loop;
+
+  grant select on pg_stat_activity to %[1]s;
 end
 $$;
 `

Original file line number	Diff line number	Diff line change
`@@ -206,6 +206,8 @@ begin`
`206`	`206`	`new_owner`
`207`	`207`	`);`
`208`	`208`	`end loop;`
	`209`	`+`
	`210`	`+ grant select on pg_stat_activity to %[1]s;`
`209`	`211`	`end`
`210`	`212`	`$$;`
`211`	`213`	`