diff --git a/vid-app-common/src/main/resources/generateRoleScript.sh b/vid-app-common/src/main/resources/generateRoleScript.sh
new file mode 100644
index 0000000..cf73b74
--- /dev/null
+++ b/vid-app-common/src/main/resources/generateRoleScript.sh
@@ -0,0 +1,3 @@
+firstRun=${1-false}
+url=http://127.0.0.1:8080/vid/generateRoleScript/$firstRun
+wget -O roles.sql $url
\ No newline at end of file