Transferring user permissions
2 posts by 2 authors in: Forums > CMS Builder
Last Post: December 14, 2011 (RSS)
By ispro - December 14, 2011
If Author A creates records, but then say, leaves the company, ideally I would like to be able to transfer Author rights to Author B. How would I do this?
Re: [ispro] Transferring user permissions
By Jason - December 14, 2011
Hi,
Records ownership is determined by the createdByUserNum field in a section, which is the record number of the user account of the person logged in when the record was created.
In order to "give" another user a persons records, all of the records with their user number in the createdByUserNum field would need to be changed to the new user.
There are a few ways to do this. If you don't have a lot of records to change, you can go into them 1 at a time as an administrator and click the "change" link at the top of the record where it shows "Created" and then a user name.
If you have a large number of records, you can accomplish this through a MySQL query. NOTE: Only try this if you are comfortable writing MySQL queries and ALWAYS backup all your data before attempting this kind of change.
Finally, a tool to accomplish this can be created as a custom plugin. If you'd like to look into that as an option, please email consulting@interactivetools.com and we can go over some options.
Hope this helps
Records ownership is determined by the createdByUserNum field in a section, which is the record number of the user account of the person logged in when the record was created.
In order to "give" another user a persons records, all of the records with their user number in the createdByUserNum field would need to be changed to the new user.
There are a few ways to do this. If you don't have a lot of records to change, you can go into them 1 at a time as an administrator and click the "change" link at the top of the record where it shows "Created" and then a user name.
If you have a large number of records, you can accomplish this through a MySQL query. NOTE: Only try this if you are comfortable writing MySQL queries and ALWAYS backup all your data before attempting this kind of change.
Finally, a tool to accomplish this can be created as a custom plugin. If you'd like to look into that as an option, please email consulting@interactivetools.com and we can go over some options.
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/