You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spamassassin.apache.org by gb...@apache.org on 2018/06/30 06:37:15 UTC
svn commit: r1834723 - in /spamassassin: branches/3.4/sql/README.bayes
trunk/sql/README.bayes
Author: gbechis
Date: Sat Jun 30 06:37:15 2018
New Revision: 1834723
URL: http://svn.apache.org/viewvc?rev=1834723&view=rev
Log:
correct syntax for GRANT with PostgreSQL
bz 7281
Modified:
spamassassin/branches/3.4/sql/README.bayes
spamassassin/trunk/sql/README.bayes
Modified: spamassassin/branches/3.4/sql/README.bayes
URL: http://svn.apache.org/viewvc/spamassassin/branches/3.4/sql/README.bayes?rev=1834723&r1=1834722&r2=1834723&view=diff
==============================================================================
--- spamassassin/branches/3.4/sql/README.bayes (original)
+++ spamassassin/branches/3.4/sql/README.bayes Sat Jun 30 06:37:15 2018
@@ -152,7 +152,7 @@ GRANT SELECT, UPDATE, DELETE, INSERT ON
GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE bayes_seen TO <username>;
GRANT SELECT, DELETE, INSERT ON TABLE bayes_expire TO <username>;
GRANT SELECT ON TABLE bayes_global_vars TO <username>;
-GRANT UPDATE, SELECT, INSERT ON bayes_vars_id_seq TO <username>;
+GRANT USAGE, SELECT, UPDATE ON SEQUENCE bayes_vars_id_seq TO <username>;
Once you have created the database and added the tables, just add the
required lines to your global configuration file (local.cf).
Modified: spamassassin/trunk/sql/README.bayes
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/README.bayes?rev=1834723&r1=1834722&r2=1834723&view=diff
==============================================================================
--- spamassassin/trunk/sql/README.bayes (original)
+++ spamassassin/trunk/sql/README.bayes Sat Jun 30 06:37:15 2018
@@ -152,7 +152,7 @@ GRANT SELECT, UPDATE, DELETE, INSERT ON
GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE bayes_seen TO <username>;
GRANT SELECT, DELETE, INSERT ON TABLE bayes_expire TO <username>;
GRANT SELECT ON TABLE bayes_global_vars TO <username>;
-GRANT UPDATE, SELECT, INSERT ON bayes_vars_id_seq TO <username>;
+GRANT USAGE, SELECT, UPDATE ON SEQUENCE bayes_vars_id_seq TO <username>;
Once you have created the database and added the tables, just add the
required lines to your global configuration file (local.cf).