Peran Cloud SQL

Peran IAM Cloud SQL bawaan

Cloud SQL menyediakan beberapa peran bawaan yang dapat Anda gunakan untuk memberikan izin yang lebih terperinci kepada anggota project.

Peran yang Anda berikan kepada anggota project mengontrol tindakan yang dapat dilakukan oleh anggota tersebut. Anggota proyek dapat berupa individu, grup, atau akun layanan. Anda dapat memberikan beberapa peran kepada anggota project yang sama, dan mengubah peran yang diberikan ke anggota project kapan saja, selama Anda memiliki izin untuk melakukannya.

Peran yang lebih luas mencakup peran yang lebih spesifik. Misalnya, peran Editor Cloud SQL mencakup semua izin peran Viewer Cloud SQL, beserta izin tambahan dari peran Editor Cloud SQL.

Demikian juga, peran Admin Cloud SQL mencakup semua izin peran Editor Cloud SQL, beserta izin tambahannya.

Peran dasar (Pemilik, Editor, Viewer) memberikan izin di seluruh Google Cloud. Peran khusus Cloud SQL hanya menyediakan izin Cloud SQL, kecuali izin Google Cloud berikut, yang diperlukan untuk penggunaan Google Cloud secara umum:

  • resourcemanager.projects.get
  • resourcemanager.projects.list
  • serviceusage.quotas.get
  • serviceusage.services.get
  • serviceusage.services.use

Tabel berikut berisi daftar peran bawaan yang tersedia untuk Cloud SQL, beserta izin Cloud SQL:

Nama
Peran		 Deskripsi
Izin Cloud SQL
roles/owner
Owner		 Akses dan kontrol penuh untuk semua resource Google Cloud; mengelola akses pengguna.

cloudsql.*
roles/editor
Editor		 Akses baca-tulis untuk semua resource Google Cloud dan Cloud SQL (kontrol penuh kecuali untuk kemampuan mengubah izin).

Semua cloudsql izin kecuali untuk
cloudsql.*.getIamPolicy cloudsql.*.setIamPolicy
roles/viewer
Viewer		 Akses hanya baca ke semua resource Google Cloud, termasuk resource Cloud SQL.

cloudsql.*.export
cloudsql.*.get
cloudsql.*.list
roles/cloudsql.admin
Admin Cloud SQL		 Kontrol penuh untuk semua resource Cloud SQL.

cloudsql.*
recommender.cloudsqlInstanceDiskUsageTrendInsights.*
recommender.cloudsqlInstanceOutOfDiskRecommendations.*
recommender.cloudsqlInstancePerformanceInsights.*
recommender.cloudsqlInstancePerformanceRecommendations.*
recommender.cloudsqlInstanceSecurityInsights.*
recommender.cloudsqlInstanceSecurityRecommendations.*
recommender.cloudsqlUnderProvisionedInstanceRecommendations.*
recommender.cloudsqlInstanceOomProbabilityInsights.*
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.*
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.*
roles/cloudsql.editor
Editor Cloud SQL		 Mengelola resource Cloud SQL. Tidak ada kemampuan untuk melihat atau mengubah izin, maupun mengubah pengguna atau sertifikat SSL. Tidak ada kemampuan untuk mengimpor atau memulihkan data dari cadangan, maupun meng-clone, menghapus, atau mempromosikan instance. Tidak ada kemampuan untuk memulai atau menghentikan replika. Tidak ada kemampuan untuk menghapus database, replika, atau cadangan.

cloudsql.instances.addServerCa
cloudsql.instances.addServerCertificate
cloudsql.instances.connect
cloudsql.instances.export
cloudsql.instances.failover
cloudsql.instances.get
cloudsql.instances.list
cloudsql.instances.listServerCas
cloudsql.instances.listServerCertificates
cloudsql.instances.migrate
cloudsql.instances.reencrypt
cloudsql.instances.restart
cloudsql.instances.rotateServerCa
cloudsql.instances.rotateServerCertificate
cloudsql.instances.truncateLog
cloudsql.instances.update
cloudsql.databases.create
cloudsql.databases.get
cloudsql.databases.list
cloudsql.databases.update
cloudsql.backupRuns.create
cloudsql.backupRuns.get
cloudsql.backupRuns.list
cloudsql.schemas.view
cloudsql.sslCerts.get
cloudsql.sslCerts.list
cloudsql.users.list
recommender.cloudsqlInstanceDiskUsageTrendInsights.get
recommender.cloudsqlInstanceDiskUsageTrendInsights.list
recommender.cloudsqlInstanceDiskUsageTrendInsights.update
recommender.cloudsqlInstanceOutOfDiskRecommendations.get
recommender.cloudsqlInstanceOutOfDiskRecommendations.list
recommender.cloudsqlInstanceOutOfDiskRecommendations.update recommender.cloudsqlInstancePerformanceInsights.get
recommender.cloudsqlInstancePerformanceInsights.list
recommender.cloudsqlInstancePerformanceInsights.update
recommender.cloudsqlInstancePerformanceRecommendations.get
recommender.cloudsqlInstancePerformanceRecommendations.list
recommender.cloudsqlInstancePerformanceRecommendations.update
recommender.cloudsqlInstanceSecurityInsights.get
recommender.cloudsqlInstanceSecurityInsights.list
recommender.cloudsqlInstanceSecurityInsights.update
recommender.cloudsqlInstanceSecurityRecommendations.get
recommender.cloudsqlInstanceSecurityRecommendations.list
recommender.cloudsqlInstanceSecurityRecommendations.update
recommender.cloudsqlUnderProvisionedInstanceRecommendations.get
recommender.cloudsqlUnderProvisionedInstanceRecommendations.list
recommender.cloudsqlUnderProvisionedInstanceRecommendations.update
recommender.cloudsqlInstanceOomProbabilityInsights.get
recommender.cloudsqlInstanceOomProbabilityInsights.list
recommender.cloudsqlInstanceOomProbabilityInsights.update
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.get
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.list
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.update
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.get
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.list
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.update
roles/cloudsql.viewer
Viewer Cloud SQL		 Akses baca saja ke semua resource Cloud SQL.

cloudsql.*.export
cloudsql.*.get
cloudsql.*.list
cloudsql.instances.listServerCas
cloudsql.instances.listServerCertificates
recommender.cloudsqlInstanceOutOfDiskRecommendations.get
recommender.cloudsqlInstanceOutOfDiskRecommendations.list
recommender.cloudsqlInstanceDiskUsageTrendInsights.get
recommender.cloudsqlInstanceDiskUsageTrendInsights.list
recommender.cloudsqlInstancePerformanceInsights.get
recommender.cloudsqlInstancePerformanceInsights.list
recommender.cloudsqlInstancePerformanceRecommendations.get
recommender.cloudsqlInstancePerformanceRecommendations.list
recommender.cloudsqlInstanceSecurityInsights.get
recommender.cloudsqlInstanceSecurityInsights.list
recommender.cloudsqlInstanceSecurityRecommendations.get
recommender.cloudsqlInstanceSecurityRecommendations.list
recommender.cloudsqlUnderProvisionedInstanceRecommendations.get
recommender.cloudsqlUnderProvisionedInstanceRecommendations.list
recommender.cloudsqlInstanceOomProbabilityInsights.get
recommender.cloudsqlInstanceOomProbabilityInsights.list
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.get
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.list
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.get
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.list
roles/cloudsql.client
Klien Cloud SQL		 Akses konektivitas ke instance Cloud SQL dari App Engine dan Proxy Auth Cloud SQL. Tidak diperlukan untuk mengakses sebuah instance menggunakan alamat addresses.

cloudsql.instances.connect
cloudsql.instances.get
roles/cloudsql.instanceUser
Pengguna Cloud SQL Instance		 Peran mengizinkan akses ke instance Cloud SQL

cloudsql.instances.get
cloudsql.instances.login
roles/cloudsql.schemaViewer
Cloud SQL Schema Viewer 		Peran yang mengizinkan akses ke skema instance Cloud SQL di Dataplex.

cloudsql.schemas.view
roles/cloudsql.studioUser
Pengguna Cloud SQL Studio 		Peran yang mengizinkan akses ke Cloud SQL Studio.

cloudsql.databases.list
cloudsql.instances.executeSql
cloudsql.instances.get
cloudsql.instances.login
cloudsql.users.list

Izin dan perannya

Tabel berikut mencantumkan setiap izin yang didukung oleh Cloud SQL, beserta peran Cloud SQL dan peran dasarnya.

Izin Peran Cloud SQL Peran lawas
cloudsql.backupRuns.create Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.backupRuns.delete Admin Cloud SQL Editor
cloudsql.backupRuns.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.backupRuns.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.databases.create Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.databases.delete Admin Cloud SQL Editor
cloudsql.databases.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.databases.getIamPolicy Admin Cloud SQL Pemilik
cloudsql.databases.list Admin Cloud SQL
Editor Cloud SQL
Pengguna Cloud SQL Studio
Viewer Cloud SQL		 Pelihat
cloudsql.databases.setIamPolicy Admin Cloud SQL Pemilik
cloudsql.databases.update Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.addServerCa Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.addServerCertificate Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.clone Admin Cloud SQL Editor
cloudsql.instances.connect Admin Cloud SQL
Klien Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.create Admin Cloud SQL Editor
cloudsql.instances.delete Admin Cloud SQL Editor
cloudsql.instances.demoteMaster Admin Cloud SQL Editor
cloudsql.instances.executeSql Admin Cloud SQL
User Cloud SQL Studio
 Pemilik
cloudsql.instances.export Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.instances.failover Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.get Admin Cloud SQL
Klien Cloud SQL
Editor Cloud SQL
Pengguna Cloud SQL Studio
Viewer Cloud SQL		 Pelihat
cloudsql.instances.getIamPolicy Admin Cloud SQL Owner
cloudsql.instances.import Admin Cloud SQL Editor
cloudsql.instances.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.instances.listServerCas Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.instances.listServerCertificates Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.instances.promoteReplica Admin Cloud SQL Editor
cloudsql.instances.resetSslConfig Admin Cloud SQL Editor
cloudsql.instances.reencrypt Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.restart Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.restoreBackup Admin Cloud SQL Editor
cloudsql.instance.rotateServerCa Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instance.rotateServerCertificate Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.setIamPolicy Admin Cloud SQL Owner
cloudsql.instances.startReplica Admin Cloud SQL Editor
cloudsql.instances.stopReplica Admin Cloud SQL Editor
cloudsql.instances.truncateLog Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.instances.update Admin Cloud SQL
Editor Cloud SQL		 Editor
cloudsql.schemas.view Admin Cloud SQL
Editor Cloud SQL
Viewer Skema Cloud SQL
 Pelihat
cloudsql.sslCerts.create Admin Cloud SQL Editor
cloudsql.sslCerts.delete Admin Cloud SQL Editor
cloudsql.sslCerts.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.sslCerts.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 Viewer
cloudsql.users.create Admin Cloud SQL Editor
cloudsql.users.delete Admin Cloud SQL Editor
cloudsql.users.list Admin Cloud SQL
Editor Cloud SQL
Pengguna Cloud SQL Studio
Viewer Cloud SQL		 Pelihat
cloudsql.users.update Admin Cloud SQL Editor
recommender.cloudsqlInstanceDiskUsageTrendInsights.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceDiskUsageTrendInsights.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceDiskUsageTrendInsights.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstanceOutOfDiskRecommendations.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceOutOfDiskRecommendations.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceOutOfDiskRecommendations.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstancePerformanceInsights.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstancePerformanceInsights.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstancePerformanceInsights.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstancePerformanceRecommendations.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstancePerformanceRecommendations.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstancePerformanceRecommendations.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstanceOomProbabilityInsights.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlInstanceOomProbabilityInsights.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlInstanceOomProbabilityInsights.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstanceSecurityInsights.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceSecurityInsights.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceSecurityInsights.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstanceSecurityRecommendations.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceSecurityRecommendations.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL		 T/A
recommender.cloudsqlInstanceSecurityRecommendations.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlInstanceUnderprovisionedCpuUsageInsights.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlInstanceUnderprovisionedMemoryUsageInsights.update Admin Cloud SQL
Editor Cloud SQL
 T/A
recommender.cloudsqlUnderProvisionedInstanceRecommendations.get Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlUnderProvisionedInstanceRecommendations.list Admin Cloud SQL
Editor Cloud SQL
Viewer Cloud SQL
 T/A
recommender.cloudsqlUnderProvisionedInstanceRecommendations.update Admin Cloud SQL
Editor Cloud SQL
 T/A

Peran khusus

Jika peran bawaan tidak memenuhi persyaratan bisnis unik Anda, Anda dapat menentukan peran khusus sendiri dengan izin yang Anda tentukan. Untuk mendukung hal ini, IAM menawarkan peran khusus.

Saat Anda membuat peran khusus untuk Cloud SQL, pastikan jika Anda menyertakan cloudsql.instances.list atau cloudsql.instances.get, atau keduanya. Jika tidak, konsol Google Cloud tidak akan berfungsi dengan benar untuk Cloud SQL.