by eggsurplus

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.

Free 30 day trial
Try it Now

#4229 - Reducing size of security groups

In Progress General Question created by sviswanath Verified Purchase one month ago

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)

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    one month 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

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      one month ago

      Also upgrade to the latest SecuritySuite version 3.1.17 if you haven't already.

    • shrinivasviswanath member avatar

      sviswanath Verified Purchase

      one month 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

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      one month 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.

    • shrinivasviswanath member avatar

      sviswanath Verified Purchase

      one month 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;?

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      one month 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.

    • shrinivasviswanath member avatar

      sviswanath Verified Purchase

      one month 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?

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      one month ago

      No, this is just for security groups to records. So you would be removing security groups from Notes only.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "I can say that it has been one of the best modules within our SugarCRM CE instance!"

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.