You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spamassassin.apache.org by pa...@apache.org on 2005/04/06 02:48:38 UTC
svn commit: r160246 - spamassassin/trunk/sql/README.bayes
Author: parker
Date: Tue Apr 5 17:48:37 2005
New Revision: 160246
URL: http://svn.apache.org/viewcvs?view=rev&rev=160246
Log:
Bug3971: Added note about Pg grants for the bayes tables
Modified:
spamassassin/trunk/sql/README.bayes
Modified: spamassassin/trunk/sql/README.bayes
URL: http://svn.apache.org/viewcvs/spamassassin/trunk/sql/README.bayes?view=diff&r1=160245&r2=160246
==============================================================================
--- spamassassin/trunk/sql/README.bayes (original)
+++ spamassassin/trunk/sql/README.bayes Tue Apr 5 17:48:37 2005
@@ -131,6 +131,18 @@
psql -U <username> -f bayes_pg.sql <databasename>
+From a security viewpoint, it is wise to grant the minimum privileges
+needed to the user on the bayes tables. These grants largely depend
+on your system policies but here are some example grants to get you
+started, please review carefully before putting into production:
+
+GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE bayes_token TO <username>;
+GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE bayes_vars TO <username>;
+GRANT SELECT, 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>;
+
Once you have created the database and added the tables, just add the
required lines to your global configuration file (local.cf).