Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to set up a Postfix mail server using MySQL for the mapping tables. As it's bad practice to simply grant all permissions unless they're needed, I want to grant only the minimal permissions required to make Postfix work.

Unfortunately, even the Postfix MySQL Howto doesn't seem to want to give up this info, and my Google-fu is inconclusive, mainly because there are a lot of pages that talk about Postfix and MySQL before going on to talk about restricting file permissions for the config :)

Can I get away with just SELECT, or does Postfix need more than this?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

You only need the SELECT permission for Postfix as it only runs SELECT queries on those tables.

In this kind of setup you are also likely to have some admin panel which will have to write to those tables. So it's best to setup a read only user for Postfix and a separate read/write user for the admin panel.

share|improve this answer
    
Thanks — I'm doing the writes over SSH from a desktop client rather than installing a web control panel, so that side's already OK :) –  John Yeates Jun 15 at 14:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.