This topic is locked

Dynamic User Permissions

8/26/2009 9:18:08 AM
PHPRunner General questions
G
GamezBeCJ author

Hi all:
I'm trying to implement an dynamic permission system where users from the same client/company can access the same records. Unfortunately, the default permission system provided by PHPRunner doesn't allow for this as each record on every table is supposed to have a field with the userid. In other words, the PHPRunner permission system is designed on a per user basis, not per group.
I guess graphically it would look like:
Company 1
User 1.1 \

User 1.2 |

User 1.3 > Access to records "marked" as Company 1

User 1.4 |

User 1.5 /
Company 2
User 2.1 \

User 2.2 |

User 2.3 > Access to records "marked" as Company 2

User 2.4 |

User 2.5 /
All users would belong to a group called "Customers" on the admin tables.
Has anyone tried to implement something similar?
I'd appreciate your comments.

Sergey Kornilov admin 8/26/2009

I guess you need to check 'Advanced security settings' -> 'Users can see and edit their own data only'.
You can choose Commpany as an OwnerID field.

L
lewisekrantz 8/27/2009



Hi all:
I'm trying to implement an dynamic permission system where users from the same client/company can access the same records. Unfortunately, the default permission system provided by PHPRunner doesn't allow for this as each record on every table is supposed to have a field with the userid. In other words, the PHPRunner permission system is designed on a per user basis, not per group.
I guess graphically it would look like:
Company 1
User 1.1 \

User 1.2 |

User 1.3 > Access to records "marked" as Company 1

User 1.4 |

User 1.5 /
Company 2
User 2.1 \

User 2.2 |

User 2.3 > Access to records "marked" as Company 2

User 2.4 |

User 2.5 /
All users would belong to a group called "Customers" on the admin tables.
Has anyone tried to implement something similar?
I'd appreciate your comments.


LK:
Step 1 Add a column named COMPANY to your main user table

Step 2 Click "Users Edit and See their own data"

Step 3 Link the "COMPANY" column in the main user table to "COMPANY" in Each Table
Works Great
If this is not clear contact me at lewisekrantz@gmail.com and I will send you screenshots