Using MySQL ACL as PHP Application Auth

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
lawrenceyeo
Forum Newbie
Posts: 1
Joined: Mon Jan 13, 2003 3:54 am
Location: Singapore
Contact:

Using MySQL ACL as PHP Application Auth

Post by lawrenceyeo »

Hi,

Currently I'm using MySQL database to store the username and password to set the auth level for different users of the application. The application is using a single MySQL database user to perform query, insert, update and delete database operation.

I'm thinking of using MySQL user login and use MySQL ACL to control which databases, tables, (and event fields) a application user can access to tighten up the security issue.

Could anyone point me to a tutorial to achieve the above or advice me if the above is over kill since the application can control what a user can perform.

Help is most appreciated.

Regards,
Lawrence Yeo
Post Reply