From 8efdf75bcb3621822523803b02bd308792bf84d5 Mon Sep 17 00:00:00 2001
From: Stan Hu <stanhu@gmail.com>
Date: Thu, 9 Nov 2017 12:18:26 -0800
Subject: Use a non-superuser user to access GitLab to ensure permissions are
 proper

We have run into permission issues with MySQL triggers in #36633 that
would have been caught earlier either if our migration tests or GitLab QA
tests had been testing against non-superuser users. This change creates
a non-superuser that has access to the GitLab test database and uses that.

Closes #39932
---
 scripts/create_postgres_user.sh | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 scripts/create_postgres_user.sh

(limited to 'scripts/create_postgres_user.sh')

diff --git a/scripts/create_postgres_user.sh b/scripts/create_postgres_user.sh
new file mode 100644
index 00000000000..8a744df3226
--- /dev/null
+++ b/scripts/create_postgres_user.sh
@@ -0,0 +1,8 @@
+#!/bin/bash
+
+psql -h postgres -U postgres postgres <<EOF
+DROP DATABASE IF EXISTS gitlabhq_test;
+CREATE DATABASE gitlabhq_test;
+CREATE USER gitlab;
+GRANT ALL PRIVILEGES ON DATABASE gitlabhq_test TO gitlab;
+EOF
-- 
cgit v1.2.1