Sugar Pro 11.0.5 not respecting Teams?

Hello Francesca Shiekh, 

The behaviour that you described doesn't sound correct. 
The causes that cross my mind are:

1 - You've mentioned that by default " Every record is "Global". If you want to restrict the visibility from other users you'll need to remove the Global team from the Record and add the New "Embargo" team. Was that performed?  

2- Does the user have any reportees? Is the user possibly having an Implicit team membership to the embargoed team? 
support.sugarcrm.com/.../index.html

3 - Do you have any customisations on custom/data/visibility/ ? 
I've seen cases of customers disabling team security to improve performance, could that be the case? 

4 - Did you run a repair teams already? 
https://support.sugarcrm.com/Documentation/Sugar_Versions/13.0/Ent/Administration_Guide/System/Repair/#Repair_Teams

Feel free to let me know if any of these guides you in the right direction or if you need any more information or ideas. 

Thanks 

André

Thank you Andre Serrazina,

to answer your questions:

• I have verified that the record has one team only "Embargoed" and no others
  
  
• I have verified that the user I use for testing does not have "Embargoed" team assigned explicitly or implicitly:
  

  SELECT tm.*, t.name
  FROM `team_memberships` tm
  INNER JOIN teams t ON tm.team_id = t.id
  WHERE tm.user_id = 'The_user_id_here';

  
  
  as a matter of fact no one has Team "Embargoed" assigned at this time as only Admins should be seeing these records at this time.
  
  
• I have repaired Teams & a QRR for good measure
  
  
• I had NOT checked the visibility customizations.
  We did have a custom/data/visibility/TeamSecurity.php (thank you for that extra tip) 
  It was added more than 5 years ago and I seriously don't remember why... 
  I removed it, QRR, and it made no difference.
  
  

• <?php
  if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
  class TeamSecurity extends SugarVisibility
  {
          public function addVisibilityFrom(&$query)
          {
                  return $query;
          }
          public function addVisibilityFromQuery(SugarQuery $query, $options = array())
          {
                  return $query;
          }
  }

  
  
  

I went as far as disabling the ACL modifications though they have nothing to do with Leads. That, as expected, did not help.

FrancescaS

Thank you Andre Serrazina,

to answer your questions:

• I have verified that the record has one team only "Embargoed" and no others
  
  
• I have verified that the user I use for testing does not have "Embargoed" team assigned explicitly or implicitly:
  

  SELECT tm.*, t.name
  FROM `team_memberships` tm
  INNER JOIN teams t ON tm.team_id = t.id
  WHERE tm.user_id = 'The_user_id_here';

  
  
  as a matter of fact no one has Team "Embargoed" assigned at this time as only Admins should be seeing these records at this time.
  
  
• I have repaired Teams & a QRR for good measure
  
  
• I had NOT checked the visibility customizations.
  We did have a custom/data/visibility/TeamSecurity.php (thank you for that extra tip) 
  It was added more than 5 years ago and I seriously don't remember why... 
  I removed it, QRR, and it made no difference.
  
  

• <?php
  if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
  class TeamSecurity extends SugarVisibility
  {
          public function addVisibilityFrom(&$query)
          {
                  return $query;
          }
          public function addVisibilityFromQuery(SugarQuery $query, $options = array())
          {
                  return $query;
          }
  }

  
  
  

I went as far as disabling the ACL modifications though they have nothing to do with Leads. That, as expected, did not help.

FrancescaS

Hi Francesca Shiekh, 

I know that code! It's from our friend and forever Sugar legend Enrico Simonetti.
Look at this: 

https://enricosimonetti.com/can-i-remove-team-security-from-sugarcrm/

This customisation would disable the team security so it would cause the behaviour that you are experiencing. 
If you removed and QRR and still doesn't work, can you try wiping the cache/ folder, and clearing the cache of the browser just to make sure?