PHP和Mysql数据库[关闭]

Question

i am stuck at one point. i have created login page, using cookie and works fine too. but my question is, i have 5 users in my one application. some of them are admin, and some of are not. and they uses same database to put and fetch information from it. so i want to create something like this, in which admin1 can access all the information upto only admin1. he/she should not be able to access the information of admin2 but he can access information of regular users. same with admin2. and for regular user, he/she should not be able to use any one's data but his/her. hope u guys will be understand the scenario, i have present. let me know if you feel confusion.

Answer 1

These sound like application permissions that should be defined at the application level and not the database level. Are you trying to give different users direct access to the database?