From: Arjen Baart <arjen@andromeda.nl>
Date: Thu, 19 Jan 2012 16:23:46 +0000 (+0100)
Subject: Added GRANTS in the database for the admin group.
X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=19b622a4495a56bb6213a86319ec9c5025d239a3;hp=e8faad27c4d9e24d22868e739841124cd424fa3c

Added GRANTS in the database for the admin group.
---

diff --git a/src/database/create.sql b/src/database/create.sql
index 5d6cab9..f93ddc7 100644
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -857,6 +857,8 @@ GRANT UPDATE ON notification_notificationid_seq TO GROUP daemon;
 GRANT SELECT ON notification_notificationid_seq TO GROUP daemon;
 GRANT INSERT ON property TO GROUP daemon;
 GRANT UPDATE ON property TO GROUP daemon;
+GRANT INSERT ON property TO GROUP admin;
+GRANT UPDATE ON property TO GROUP admin;
 GRANT INSERT ON history TO GROUP daemon;
 GRANT INSERT ON parameter_class TO GROUP admin;
 GRANT UPDATE ON parameter_class TO GROUP admin;
diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index 61c464b..2864044 100644
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -663,11 +663,15 @@ case 43:
      $local_sql .= " VALUES ('filesystem', 'Ifree', 'Number of i-nodes available', 'DYNAMIC', 1000, 1000000, 't')";
      $dbms->query($local_sql);
 
-/*
-TODO:
+   case 53:
+
+     $dbms->query("GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin");
 
-GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin;
+     $dbms->query("GRANT INSERT ON property TO GROUP admin");
+     $dbms->query("GRANT UPDATE ON property TO GROUP admin");
 
+/*
+TODO:
 */
 //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
 /*
diff --git a/src/gcm_daemon/gcm_daemon.php b/src/gcm_daemon/gcm_daemon.php
index d4292e1..d6a314d 100755
--- a/src/gcm_daemon/gcm_daemon.php
+++ b/src/gcm_daemon/gcm_daemon.php
@@ -110,7 +110,7 @@ require_once "db.class.php";
 $project_name   = "gnucomo";    // name of the entire project
 $app_name       = "gcm_daemon"; // name of the application running
 $developrelease = "FALSE";      // Indicates if special debug settings are needed
-$db_version     = 53;           // The db_version indicates what the level of
+$db_version     = 54;           // The db_version indicates what the level of
                                 // the database should be. If the database is
                                 // old an update will be generated.
 $gcmd_version   = 5;            // This value indicates the active version of