An enterprise data team is configuring IAM permissions for an automated data processing service account. The service account needs to execute BigQuery query jobs and modify table contents only within a single project named `analytics-warehouse-prod`. Security policy mandates strict adherence to the principle of least privilege while preventing permission inheritance across adjacent production projects. Which IAM role assignment strategy should you use?
- Grant the BigQuery Job User (`roles/bigquery.jobUser`) and BigQuery Data Editor (`roles/bigquery.dataEditor`) roles to the service account bound specifically at the `analytics-warehouse-prod` project level.Cevap
- BGrant the primitive Editor (`roles/editor`) role to the service account bound at the `analytics-warehouse-prod` project level.
- CGrant the BigQuery Data Editor (`roles/bigquery.dataEditor`) role to the service account bound at the parent Folder level containing all production projects.
- DGrant the BigQuery Admin (`roles/bigquery.admin`) role to the service account bound at the Organization root level.
Cevap
Grant the predefined BigQuery Job User and BigQuery Data Editor roles specifically at the target project level.
Combining the predefined roles BigQuery Job User and BigQuery Data Editor at the project scope satisfies all operational requirements (running jobs and modifying tables) while adhering to the principle of least privilege and scoping access strictly to the intended project.
Adım Adım Çözüm
Anahtar Kavram
Applying Least Privilege using Predefined IAM Roles and Appropriate Resource Hierarchy Scope