Database Setup For Users/members/roles

Yii 1.1 General Discussion
1

Hi all,

I’m developing an website where i want guests/or public users (who aren’t validated) to be treated as a special guest user without logging in. This would be one role of many, others being, unvalidated, banned, member, admin, etc etc. I’ve got three main tables linked to this usage, the sessions table, users table and the members table, session table works in that it stores a session via the yii barebones app, u’ve also made a member table who have more stores detail to the user table, which will have email address, username, password etc. The member table is foreign keyd to the users table via the userID and the session table is linked to the users table (remembering there is a public user that isn’t a member) via the userID. Does this seem overkill?

I don’t know enough about rbac and i’ve read up loads, but still fail to grasp. Can anyone confirm they get what I am trying to achieve? And think of a way forward for me?

Thanks,

Deian

2

From the first paragraph, you seem to want a defaultRole to all non-logged in users.

Secondly, about RBAC, the database schema is located at yii/web/auth/schema-mysql.sql

Then in your Controller you set up filters() with accessControl key.

After that, create accessRules() method and set the permissions, example:

array(‘deny’,‘action’ => ‘someAction’, ‘users’ => ‘?’)

3

Thanks for the reply, so i can implement those three tables, but how can that tie in with what i’ve already designed? or would I have to redesign a little?

Regards,D