From a9ffcd7c590fc5d3a3a9e701161826172f89c9e8 Mon Sep 17 00:00:00 2001 From: "Guillaume (ioguix) de Rorthais" Date: Mon, 26 Oct 2009 06:48:48 +0100 Subject: [PATCH] pg > 8.1 does not support privilege RULE on table or view --- classes/database/Postgres.php | 4 ++-- classes/database/Postgres83.php | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/classes/database/Postgres.php b/classes/database/Postgres.php index 463105ef..b9e4e704 100755 --- a/classes/database/Postgres.php +++ b/classes/database/Postgres.php @@ -107,8 +107,8 @@ class Postgres extends ADODB_base { // List of all legal privileges that can be applied to different types // of objects. var $privlist = array( - 'table' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'RULE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), - 'view' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'RULE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), + 'table' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), + 'view' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), 'sequence' => array('SELECT', 'UPDATE', 'ALL PRIVILEGES'), 'database' => array('CREATE', 'TEMPORARY', 'CONNECT', 'ALL PRIVILEGES'), 'function' => array('EXECUTE', 'ALL PRIVILEGES'), diff --git a/classes/database/Postgres83.php b/classes/database/Postgres83.php index 7fcc2ee4..fa428599 100644 --- a/classes/database/Postgres83.php +++ b/classes/database/Postgres83.php @@ -15,8 +15,8 @@ class Postgres83 extends Postgres { // List of all legal privileges that can be applied to different types // of objects. var $privlist = array( - 'table' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'RULE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), - 'view' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'RULE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), + 'table' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), + 'view' => array('SELECT', 'INSERT', 'UPDATE', 'DELETE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'), 'sequence' => array('SELECT', 'UPDATE', 'ALL PRIVILEGES'), 'database' => array('CREATE', 'TEMPORARY', 'CONNECT', 'ALL PRIVILEGES'), 'function' => array('EXECUTE', 'ALL PRIVILEGES'), -- 2.39.5