Search code examples
google-cloud-platformgoogle-cloud-sql

How can I limit the access to a database in google cloud import interface?

I have a Google Cloud SQL server running MySQL that is used by low technical knowledge users to import csv's to a MySQL database. They use the Import function built into GC SQL. However, there are several databases and I would like to limit access to a database to each user.

Here is the menu that I refer to: https://i.sstatic.net/V4Ftq.png

I already tried assigning a IAM Role with less access but everything excep SQL Admin greyes out the Import option. SQL Admin gives complete access to even delete the instance so its definitely not an option.

Any help would be greatly appreciated.

Solution

  • You can't. Indeed, IAM role allow you to control access to GCP component. Here, your requirements is to administrate user that access to specific database schema, which is the role of DBA.

    The only solution is to build something on top of Google API for limiting/controlling access.