Database management

International Indian
1

How do I do the database management for multiple users?

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

2

what do you mean by multiple users?

3

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.

4

The best stuff for Yii : http://www.yiiframework.com/doc/guide/

You can use role based access control (RBAC)

http://www.yiiframework.com/doc/guide/1.1/en/topics.auth#role-based-access-control

5

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

6

The help section can help you -http://www.yiiframework.com/doc/guide/

7

Hi,

http://www.yiiframework.com/extension/hierarchical-rbac

or

http://www.yiiframework.com/extension/srbac

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

please check it and if getting functions please explain here.

Thanks