Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#4229 - Reducing size of security groups
Hi Team,
We would like to know what records are saved in 'securitygroups_records'. We would also like to reduce the size of this table as it is over 10gb.
Kindly let us know how we can achieve in reducing the size of this table.
Product ' SecuritySuite - SuiteCRM & CE Teams' is installed on SuiteCRM Version 7.5.3 sugar version 6.5.23 (Build 1061)
-
"Couldn't do without it. Highly recommended and I guarantee that you will not find another alternative."
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
5 years ago
Hello,
Be sure to check out all of the tips here for reducing your table size: https://www.sugaroutfitters.com/docs/securitysuite/optimizing-securitysuite
Also reassess how you are using security groups. The number of groups should be fairly static once you are set up. If you are needing to constantly create new groups that would be worth looking at in more depth to see why and if there is a better way to manage that need.
Hope this helps! -Jason
5 years ago
Also upgrade to the latest SecuritySuite version 3.1.17 if you haven't already.
5 years ago
Hi Jason,
Security groups were created during the time of setup and on requirement on very few occasions.
Also we need to know what records are stoned in this table?
Meanwhile we will check if we can upgrade to latest SecuritySuite version of 3.1.17
5 years ago
This table contains the relationship between the security groups and your data records. For example, your contacts and any security groups assigned to it. Do also check to see if you have any processes that you have set up that may be creating these entries in the table. If so, perhaps duplicates are being created. It shouldn't be that large of a table unless you have millions of records in general.
5 years ago
Will every record in CRM may be it Calls, Notes, Emails, or any other stuff will have entry in Security group? Eg. If any user creates a note, will this record also be added in 'securitygroups_records;?
5 years ago
Depends on your configuration. If you go to Admin->SecuritySuite->SecuritySuite Settings you can find all of your inheritance configurations for how groups get automatically added to new records and also any default group settings for new records.
More info about the options on that Settings page can be found here: https://www.sugaroutfitters.com/docs/securitysuite/options
Any time a group is assigned to a record it inserts into the securitygroups_records table. Maintaining that relationship is the sole purpose of that table.
5 years ago
What if we need to remove the records for say Notes. Will the relationship between Leads and Notes or Contacts and Notes will get removed?
5 years ago
No, this is just for security groups to records. So you would be removing security groups from Notes only.