Add default 'ADMIN' role and grant it to 'admin' user.

diff --git a/enyo-client/database/source/manifest.js b/enyo-client/database/source/manifest.js
index 67e8c94..1f59a8b 100644 (file)
--- a/enyo-client/database/source/manifest.js
+++ b/enyo-client/database/source/manifest.js
@@ -218,6 +218,7 @@
     "public/tables/comment_trigger.sql",
     "public/tables/pkghead.sql",
     "public/tables/schemaord.sql",
+    "priv.sql",
     "update_version.sql"
   ]
 }

diff --git a/enyo-client/database/source/priv.sql b/enyo-client/database/source/priv.sql
new file mode 100644 (file)
index 0000000..4c3e870
--- /dev/null
+++ b/enyo-client/database/source/priv.sql
@@ -0,0 +1,7 @@
+-- Setup default 'ADMIN' role and grant it to 'admin' user it it doesn't exist.
+
+-- Add 'ADMIN' Role.
+select xt.add_role('ADMIN', 'Administrators Role');
+
+-- Grant 'admin' user 'ADMIN' Role.
+select xt.grant_user_role('admin', 'ADMIN');