ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

[gtrep_security_group] Admin groups have sg_admin='N' and 'Y'


Article ID: 144830


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)



I was working on creating a tile in project where if current login user is in admin group it controls project drop down list for some custom functionality for reporting on Find and Reserve. So they would all be testers but within the Tile the list of projects they see would only be where they are member of group  sg_admin=Y.  Is this due to project being created in Datamaker? I don't know how each was created. Is there another join I can use that is more consistent?

SELECT    [sg_admin], count(*)    

  FROM [gtrep].[dbo].[gtrep_security_group] where sg_name like 'Admin%'  

  group by sg_admin

gives me 20 N and 16 Y

Real SQL is below

SELECT distinct    PROJ_NAME 

  FROM [gtrep].[dbo].[gtrep_security_ldap_group] GSLG

  inner join [dbo].[gtrep_security_groupldap_g]  GSGLG on GSGLG.[sglg_slg_id] = GSLG.[slg_id]

  inner join [dbo].[gtrep_security_group] GSG on GSGLG.sglg_sg_id = GSG.sg_id

  inner join [dbo].[gtrep_security_usergroup] GSUG on GSUG.[sug_sg_id]= GSGLG.sglg_sg_id

  inner join [dbo].[gtrep_security_user] GSU on GSUG.sug_su_id = GSU.su_id

  inner join dbo.gtrep_project GP on GSG.[sg_proj_id] = GP.proj_id

   inner join dbo.findandreservemodels FARM on farm.Projectname = GP.proj_name  /* 

   and GP.proj_id = farm.Project

  where    /* [sg_admin]='Y' and */ SU_NAME  ='sina2ee' 


Release : 4.7

Component : CA Test Data Manager


The sg_admin column is set to 'Y' (= is administrator group) if this group was granted all functions ("Select All Functions" is checked in the group details). It doesn't have relation to group name or how the group was created - it's possible to create group "Users" with sg_admin equals to 'Y' or group "Admins" with sg_admin equals to 'N'.