9

I'm trying to create a user that can only read from a database. This is the user creation screen on phpMyAdmin. For the first set (Data), I figured I only need SELECT. But I'm not sure about the second and third sets (Structure and Administration). Some options like Event Trigger Execute are a bit confusing. Do I need those for a read-only user? What exactly do I need to enable/disable?

enter image description here

Improve this question

3 Answers 3

Reset to default
16

If the user should only be able to read the database, they should not be granted any of the permissions listed under "Structure" or "Administration".

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

5

First section is only about managing with table's data and you only need SELECT privilege to have a read-only user.

Improve this answer

Comments

4

Disable everything in 'structure' and 'administration'. There's is no point in giving a person read-only rights on a table/db while leaving them the ability to completely destroy that same table/db.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.