QuestionQ73

VerifiedManage a solution that can span multiple database solutions

You are a DBA for a Cloud Spanner instance that has multiple databases. You must grant all application-development team members the following privileges on one specific database:

  • Read tables, views, and DDL
  • Write rows to the tables
  • Add columns and indexes
  • Not drop the database

What should you do?

Explanation

The Cloud Spanner Database User role permits reading and writing data and updating a database schema through spanner.databases.updateDdl, enabling additions such as columns and indexes. It does not grant spanner.databases.drop, so it meets the required restriction.

Learn more

Community Discussion

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