correct attributes for a user to access the mysql database

[terryben]

ok folks,

I seem to have everything correctly working on my website. My main concern is security of the mysql database. I have my user and password created, but I am not sure what the proper attributes should be.

Anyone have any suggestions on what the attributes should be for the user id that I will use for all visitors to the web site to read records from the database, or add records to the database. That is all the functionality that I want to give users who visit the site.

Regards,

Terry

[Catweasel]

Originally posted by terryben
I have my user and password created, but I am not sure what the proper attributes should be.

Anyone have any suggestions on what the attributes should be for the user id that I will use for all visitors to the web site to read records from the database, or add records to the database.

No doubt someone will correct me if I'm wrong, but "Select" and "Insert" should be enough. At least, they're enough for me ;)

That's for the basic webpage user - I have a remote administration user that has more (but not total) functionality to allow for modifying ("Update") and deleteing ("Delete") entries. Depending what script you're using, the basic user may also need this functionality (if the board/whatever allows users to edit/delete their own postings)