🧠 Google User has both Service Account Admin and Service Account User roles assigned - prod.logic.yaml 🟢

• Contextual name: 🧠 prod.logic.yaml 🟢
• ID: /ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml
• Located in: 📝 Google User has both Service Account Admin and Service Account User roles assigned 🟢

Flags

• 🟢 Logic test success
• 🟢 Logic with extracts
• 🟢 Logic with test data

Input Type

	Type	API Name	Extracts	Extract Files	Logic Files
🔒	📕 Google User	CA10G1__CaGoogleUser__c			2

Uses

• 🔌 Google IAM Policy Binding - object.extracts.yaml
• 🔌 Google IAM Role - object.extracts.yaml
• 🧪 test-data.json

Test Results 🟢

Generated at: 2025-04-24T23:47:04.560427748Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	INCO001	✔️ 199	✔️ CA10G1__Google_IAM_Policy_Bindings__r.count(INCOMPLIANT) > number(1.0)	✔️ null
🟢	CO001	✔️ 200	✔️ otherwise	✔️ null

Generation

	File	MD5
Open	/ce/ca/google/iam/service-account-related-roles-to-users/policy.yaml	69DE9D556295DEACE0D15F48EBBDB6AD
Open	/ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml	9DDDF92CF2226B701706701D832B7EA7
Open	/ce/ca/google/iam/service-account-related-roles-to-users/test-data.json	7EBEE650A026C2A9DE356023B0DD0099
Open	/types/CA10__CaGoogleIamPolicyBinding__c/object.extracts.yaml	DA65DB880E2440923287921FF4E70B30
Open	/types/CA10__CaGoogleIamRole__c/object.extracts.yaml	545CD4D347F041DCDD9980D122D63882

Generate FULL script

java -jar repo-manager.jar policies generate FULL /ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml

Generate DEBUG script

java -jar repo-manager.jar policies generate DEBUG /ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml

Generate CAPTURE_TEST_DATA script

java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml

Generate TESTS script

java -jar repo-manager.jar policies generate TESTS /ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml

Execute tests

java -jar repo-manager.jar policies test /ce/ca/google/iam/service-account-related-roles-to-users/prod.logic.yaml

Content

Open File

---
inputType: "CA10G1__CaGoogleUser__c"
testData:
  - file: test-data.json
conditions:
   - status: "INCOMPLIANT"
     currentStateMessage: "User has 'Service Account Admin' and 'Service Account User' roles assigned at the same time."
     remediationMessage: "Remove an extra role from the user."
     check:
      GREATER_THAN:
        left:
          RELATED_LIST_COUNT:
            status: "INCOMPLIANT"
            relationshipName: "CA10G1__Google_IAM_Policy_Bindings__r"
        right:
          NUMBER: 1.0
otherwise:
  status: "COMPLIANT"
  currentStateMessage: "The principle of 'Separation of Duties' is enforced."
relatedLists:
  - relationshipName: "CA10G1__Google_IAM_Policy_Bindings__r"
    importExtracts:
      - file: "/types/CA10__CaGoogleIamPolicyBinding__c/object.extracts.yaml"
      - file: /types/CA10__CaGoogleIamRole__c/object.extracts.yaml
    recordTypes:
      - "caGoogleIamPolicyBindingProject"
      - "caGoogleIamPolicyBindingFolder"
      - "caGoogleIamPolicyBindingOrganization"
    conditions: 
      - status: "COMPLIANT"
        currentStateMessage: "Empty policy binding"
        check:
          IS_EMPTY_LOOKUP: "CA10__iamRole__r"
      - status: "INCOMPLIANT"
        currentStateMessage: "User has a service-account related role assigned"
        check: 
          OR:
            args:
              - IS_EQUAL:
                  left:
                    EXTRACT: "CA10__iamRole__r.CA10__roleName__c"
                  right:
                    TEXT: "roles/iam.serviceAccountAdmin"
              - IS_EQUAL:
                  left:
                    EXTRACT: "CA10__iamRole__r.CA10__roleName__c"
                  right:
                    TEXT: "roles/iam.serviceAccountUser"
    otherwise:
      status: "COMPLIANT"
      currentStateMessage: "User doesn't have a service-account related role assigned"