How to Setup Roles and Permission Properly?

Questions
1

Dear Guys,

Have you successfully setup the roles and permission feature? May I know how did you do it?
I ham having problem setting up for different users with no luck. I cannot see the role_id column in users table :smiley:

Regards,

2

you need to create firstly an empty users table:
username
password
email
role
picture

then you assign the fields.

1 Like
3

Hi VMX,

For the role field what data type is that? varchar or int?

I tried varchar and int but still not working :smiley:

Thanks,

4

Voce poderia encaminha o sql da sua tabela users?