This topic is locked

Group Permissions Version 3

1/10/2006 10:08:42 AM
PHPRunner General questions
prleo1 author

Admin,
I am trying to use the new Group Permissions addition to PHPRunner. However, when I select the GroupID in my users table at the "Define user group Permissions" window, there are a number of blank rows instead of the name of the groups in the dropdown.
My table structure is as followed:
users Tbl - Note this is the table that was selected at the Create login window

user_id

username

password

permis_id - fk
Perm Tbl - Permissions Table

permis_id - pk

permis_name

permis_desc

Sergey Kornilov admin 1/11/2006

Hi,
You don't need a separate permissions table to setup user group permissions in PHPRunner.

the dropdown box in Add new user group dialog displays the values you have in usersTbl.permis_idfield.

If your UsersTbl table is empty, you can use Create new user groupoption.
I.e. you plan to have have 3 user groups:

1 - admin

2 - power user

3 - regular user
Then add groups - 1,2 and 3using Create new user group option and give them appropriate permissions.

And later when adding users you should assign them1,2 or 3user group in permis_id field.