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).