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.
Community Discussion