[Pdns-users] SELECT only access for pdns user or not?
powerdns at philip.pjkh.com
powerdns at philip.pjkh.com
Fri Feb 3 19:00:19 UTC 2006
Hi -
I just setup powerdns in a test environment and have a question regarding
necessary privileges for the pdns user when using a database (pgsql) backend.
There's conflicting information in the docs... which leads to my question: Is
it necessary for the pdns user to have anything other than SELECT access to the
tables?
http://downloads.powerdns.com/documentation/html/considerations.html
Most database backends will only need SELECT privilege. Take care to
not
connect to your database as the 'root' or 'sa' user, and configure the
chosen user to have very slight privileges.
http://downloads.powerdns.com/documentation/html/configuring-db-connection.html
GRANT SELECT ON supermasters TO pdns;
GRANT ALL ON domains TO pdns;
GRANT ALL ON records TO pdns;
I'm running right now with just SELECT privileges and it seems to work. Only
reason I can think it would need anything more would be for slave use, yes?
Thanks!
-philip
More information about the Pdns-users
mailing list