• Registered: 2004-11-30
  • Posts: 3

Topic: What privileges does my DB user need?

I want to create a limited user with only the necessary privileges for running PunBB. What should be granted from below? (And are there any differences between pun 1.2.x and 1.1.x?)

ALTER
CREATE TEMPORARY TABLES
CREATE
DELETE
DROP
SELECT
INSERT
UPDATE
REFERENCES
INDEX
LOCK TABLES

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: What privileges does my DB user need?

DELETE, SELECT, INSERT and UPDATE should suffice once you've installed the forums. To install/update, you would need CREATE, ALTER and maybe DROP.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-11-30
  • Posts: 3

Re: What privileges does my DB user need?

Thanks, Rickard.