Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Building Google Cloud Platform Solutions

You're reading from   Building Google Cloud Platform Solutions Develop scalable applications from scratch and make them globally available in almost any language

Arrow left icon
Product type Course
Published in Mar 2019
Publisher Packt
ISBN-13 9781838647438
Length 778 pages
Edition 1st Edition
Languages
Arrow right icon
Authors (3):
Arrow left icon
Steven Porter Steven Porter
Author Profile Icon Steven Porter
Steven Porter
Legorie Rajan PS Legorie Rajan PS
Author Profile Icon Legorie Rajan PS
Legorie Rajan PS
Ted Hunter Ted Hunter
Author Profile Icon Ted Hunter
Ted Hunter
Arrow right icon
View More author details
Toc

Table of Contents (29) Chapters Close

Title Page
Copyright and Credits
About Packt
Contributors
Preface
1. Why GCP? FREE CHAPTER 2. The Google Cloud Console 3. APIs, CLIs, IAM, and Billing 4. Google App Engine 5. Google Kubernetes Engine 6. Google Cloud Functions 7. Google Compute Engine 8. NoSQL with Datastore and Bigtable 9. Relational Data with Cloud SQL and Cloud Spanner 10. Google Cloud Storage 11. Stackdriver 12. Change Management 13. GCP Networking for Developers 14. Messaging with Pub/Sub and IoT Core 15. Integrating with Big Data Solutions on GCP 16. Compute 17. Storage and Databases 18. Networking 19. Security 20. Machine Learning and Big Data 21. Management Tools 22. Best Practices 1. Other Books You May Enjoy Index

Cloud SQL IAM and users


Cloud SQL employs two forms of access control: traditional GCP IAM policies and native database user controls. With the exception of Cloud SQL Client, IAM policies apply to all Cloud SQL operations within a given project, and are largely focused on administrative tasks on the instances themselves. Database users offer a more fine-grained level of control over database access, such as which tables a client can read and modify.

IAM policies

Other than the primitive IAM roles that apply to all project resources (owner, editor, viewer), Cloud SQL supports four IAM roles:

  • roles/cloudsql.admin: Full control, except the ability to connect as a client
  • roles/cloudsql.editor: Ability to perform operational tasks on an instance
  • roles/cloudsql.viewer: Read-only access to all resources
  • roles/cloudsql.client: Ability to connect to an instance via the Cloud SQL Proxy

Database users

Cloud SQL offers a simple managed interface for controlling database users in a given Cloud SQL instance....

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime