From 19b622a4495a56bb6213a86319ec9c5025d239a3 Mon Sep 17 00:00:00 2001 From: Arjen Baart Date: Thu, 19 Jan 2012 17:23:46 +0100 Subject: [PATCH] Added GRANTS in the database for the admin group. --- src/database/create.sql | 2 ++ src/gcm_daemon/classes/gnucomo_db_version.php | 10 +++++++--- src/gcm_daemon/gcm_daemon.php | 2 +- 3 files changed, 10 insertions(+), 4 deletions(-) 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 -- 2.11.0