2. PHPRunner General questions
  3. [SOLVED]  How to create different sets of User Groups?
This topic is locked
[SOLVED]

 How to create different sets of User Groups?

 		6/20/2011 12:57:12 PM
PHPRunner General questions
I
 imthebest author

I am developing an application which can be used by group of organizations. The requirement is that there can be a superadmin who can set-up different organizations. Each organisation will have its own set of User Groups. For example, Org 1 will have User Groups like Manager, Support Staff, Technical staff etc. Org 2 have User Groups like President, Senior Engineer, Technical Leads etc. User from each organization can see the data of their own organization only. The access rights are also different for users of different organization. I am able to do all the set-up for this. But I am stuck on creation of different User Groups for different organization.
WHen I use Security option in phprunner, there is an option to add User Groups. But, I could not understand, where these groups are stored? How can I create different groups for different Organization?
Any information that explains where User Groups in phprunner store? How that work, can help me to design the system.
Please help.
Thanks in advance.
C
 		cgphp 6/20/2011

There are two ways to create user groups: static permissions and dynamic permissions.
According to your requirements the best way is the second one.
http://xlinesoft.com/phprunner/docs/dynamic_permissions.htm
Cheers

CGphp
I
 		imthebest author 6/21/2011



There are two ways to create user groups: static permissions and dynamic permissions.
According to your requirements the best way is the second one.
http://xlinesoft.com/phprunner/docs/dynamic_permissions.htm
Cheers

CGphp


Thanks CGphp.
I am aware of static and dynamic permissions. If I understand correct, even Dynamic permissions, allows to create only one set of User Groups. As I mentioned, I need to create different sets of User Groups for different organizations in the same project. Admin from one organization can add/modify User Groups and users of his organization only.
Any direction, how to design the same using Dynamic permission, will certainly help.
Thanks in advance.
Sergey Kornilov admin 6/21/2011

Unfortunately PHPRunner is not able to provide a different set of group permissions for each organization.
I
 		imthebest author 6/21/2011

Hi Admin,
Thanks for reply.
I have a point to discuss here. I noticed that the three tables which are generated by Dynamic Permission (viz. ugmembers, uggroups and ugrights) are not displayed in "datasource table" list like other tables are displayed. (only views are displayed) If these tables are displayed like any other table then I will able to perform some operations on these tables. That way I can achieve this functionality and many other security related functionalities that I wish to achieve.
Is there any way to get these tables displayed in "Datasource Tables" and be allowed to work with like any other table?
Thanks,
Sergey Kornilov admin 6/21/2011

You can add those table as "normal" tables to your project.
I
 		imthebest author 6/23/2011



You can add those table as "normal" tables to your project.


Hi Admin,
Thanks for information.
As suggested, I created these three tables directly in phpmyadmin. I kept the names and table structure same. These tables are now existing in mysql database. But when I opened phprunner and my project, I did not find these tables in datasource tables. It looks like that the database synchronisation is not happening. I am using phprunner 4.2.
I then downloaded trial version of phprunner 5.3 and opened my old project using phprunner 5.3. I was able to see these three tables in datasource tables. I am totally stumped. I am not able to see these tables in datasource tables when opening the project using phprunner 4.2, but can see them when opening the same project using phprunner 5.3.
I remember that you once mentioned that db sync is automatic in ver 4.2. But in my case, synching is not happening always. Is there any datbase sychronisation related bug in phprunner 4.2? If so, Can I get any patch that can fix sync issue?
Please advice.
Thanks in advance.
Sergey Kornilov admin 6/23/2011

We haven't heard of synchronization issues in PHPRunner 4.2.
I recommend to contact support directly providing your order number, project file and database.
I
 		imthebest author 6/24/2011



We haven't heard of synchronization issues in PHPRunner 4.2.
I recommend to contact support directly providing your order number, project file and database.



Hi Admin,
Sorry to open the SOLVED post.
I discovered one thing. It looks like that the issue is not with DB synchronisation. But it is with the "names" of these three tables. I re-named these three tables using phpmyAdmin, and I was able to see these three tables in Datasource tables. I tested again by giving them original names i.e. uggroups, ugmembers and ugrights. And the tables were disappeared from Datasource tables.
It looks like that phprunner 4.2 does not allow to display _these tables only_in datasource tables. Perhaps it is designed in such a way so that user cannot do any operation on these three tables. Is that right?
Please advise.
Regards.