Database management

How do I do the database management for multiple users?

I am going to develop an Store Management Software based on Yii framework.

what do you mean by multiple users?

multiple users means they are sitting on each machines

and using different roles (ie. data entry operator, administrator, report viewer and analyzer etc.) type logins.

The best stuff for Yii :

You can use role based access control (RBAC)

there is a keyword called GRANT in mysql… It will allocate the priveleges to diff userssss

The help section can help you -



I have a installed but no idea about how to work these.

please check it and if getting functions please explain here.