Using 5.31
It would be very useful, if, when the admin changes the group a person belongs to all the records associated with that member also change to reflect the new group they are in. This is a manual process right now.
It can happen and be very useful to have this feature.
Scenario:
A person signs up as a basic user. Not all rights to all tables. Later they get upgraded for whatever reason and so you change their group from 'basic' to 'basic+1'. Right now all their record ownerships have to be changed manually.
If someone knows of an easy way to do this it would be great. Otherwise I will write, for now, my own code to do this.
(Or maybe it does do it and it is just my instance that is not working) Can anyone let me know if it works differently for them.
Thanks
Alan
Change record ownership if group changed
Change record ownership if group changed
Calgary, Alberta, Canada - Using Appgini 5.50 -
Re: Change record ownership if group changed
Actually the code I am writing will ask the admin if they wish to also change the ownership of all records created/owned by this user when their group is changed. This way it gives a bit better flexibility to making the change.
The user then still has access to all their records. Otherwise the user cannot see their older records I am finding.
The reason I need to change a user's group is to allow the following:
I need a set of users, lets call them minor admins, to be able to see all the records for all users who have stated a particular allegiance. I do not want the minor admin to be able to see other records of other users who have not stated that allegiance. By changing the group of the users to another group I can then easily allow the minor admin to see all the records of that group by putting the minor admin in the same group but giving them greater access rights. Doing it this way makes it very using, using table privileges, to control which users in that group can see other records. A one click type of solution.
Process would be as follows:
Select one user of the group and give them the right to see all records for all in that group using group settings. It is easier to do this if done by groups. But first have to increase the number of groups. Basically what I am doing is using the groups as a way to select certain members to allow another member greater access.
Alan - using 5.31
The user then still has access to all their records. Otherwise the user cannot see their older records I am finding.
The reason I need to change a user's group is to allow the following:
I need a set of users, lets call them minor admins, to be able to see all the records for all users who have stated a particular allegiance. I do not want the minor admin to be able to see other records of other users who have not stated that allegiance. By changing the group of the users to another group I can then easily allow the minor admin to see all the records of that group by putting the minor admin in the same group but giving them greater access rights. Doing it this way makes it very using, using table privileges, to control which users in that group can see other records. A one click type of solution.
Process would be as follows:
Select one user of the group and give them the right to see all records for all in that group using group settings. It is easier to do this if done by groups. But first have to increase the number of groups. Basically what I am doing is using the groups as a way to select certain members to allow another member greater access.
Alan - using 5.31
Calgary, Alberta, Canada - Using Appgini 5.50 -