QuestionQ96

VerifiedConfiguring access and security

Your organization needs to grant users access so they can query datasets in BigQuery, but you want to prevent them from accidentally deleting the datasets. You want a solution that follows Google-recommended practices. What should you do?

Explanation

Google's IAM best practices recommend granting roles to groups rather than to individual users, to simplify access management and auditing, and recommend using custom roles to enforce least privilege when predefined roles grant more permissions than needed. Since roles/bigquery.dataOwner includes delete permissions, the least-privilege approach is to create a custom role that excludes delete permissions and assign that custom role to a Google Group, then add the users who need query access to that group. This combines least privilege (no delete capability) with the recommended group-based IAM management approach.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!