MySQL Forums
Forum List  »  Newbie

Re: Recommended User Administration Structure & Privileges?
Posted by: Jeff Smith
Date: February 02, 2015 01:43PM

Should I just use the "Data" Privileges for the php database connection options that include - "Select", "Insert", "Update", and "Delete". I can't think of any reasons to allow the user account to alter the structure of the table, so I don't think any privileges in the "Structure" section should be given. Lastly, I'm not sure about the "Administration" Privileges. My gut tells me to only allow the "Lock Tables" and "References", and to not allow the "Grant" privilege.

Does that sound about right?

Options: ReplyQuote


Subject
Written By
Posted
Re: Recommended User Administration Structure & Privileges?
February 02, 2015 01:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.