2. PHPRunner General questions
  3. Users and Groups
This topic is locked

Users and Groups

 		10/26/2007 14:34:46
PHPRunner General questions
G
 glav author

Hello, I'm thinking about buying but not sure about Security options. I'm using the trial and maybe it is limited but the security options are a little fuzzy to me.
What I'm trying to do is have a user table (tbl_Users) that has a field called fld_User_Type and this field should be populated by values in the table (tbl_User_Types) fields (fld_User_Type_ID) & (fld_User_Type_Name). So we will have Guest, Moderator and Admin.
I want the User Type edited only by admins and when a user signs up he is automatically a guest until an admin upgrades him to a moderator or admin. Is this possible or should I be going about it in a different way?
Thanks
Sergey Kornilov admin 10/26/2007

You need to use User Group Permissions for this purpose. Choose fld_User_Type_Name as a GroupID field (I assume this is the field that stores group names).
Using User Group permissions you can control what tables can accessed by each group.
You might need to enable Guest login if you like users to access certain tables without logging in first.
A
 		arrowhot 1/18/2008

Along the same line of question Sergey.

If I establish group access, with groups defined such as admin versus regular user, I can restrict access to certain tables.
But is there a way to restrict access fields within a table?
For example, I might want to have user be able to see the user table fields (username, address, phone), but not see the password field.
Thoughts?
(I just upgraded my phprunner to the latest release. As usual, you deserve a round of applause for a GREAT product !!!!)
J
 		Jane 1/21/2008

Hi,
you can't restrict access to individual field.

As workaround you can create custom view for admin on the Datasource tables tab and setup corresponding permissions for this view on the User group permissions dialog on the Security tab.