Problem with privileges : can't run a query with postgres user with generated symfony db

[Alessandro CANDON -ITALY-]

I'm facing a very hard problem to solve with GCP cloud SQL. My tech stack is GCP with k8s for the hosting, using proxy to connect to sql db. Symfony project for the backend.

I follow these steps to create and populate ( without success ):

1. Create sql postgres instance
2. Add proxy to k8s container to connect to the sql instance with all credentials as is described in gcp doc
3. Enter inside my Symfony ( phpfpm ) pod and run the command php bin/console doctrine:schema:update --force and all the query are executed in the database, so the schema is created and so on...
4. I try to open the DB fron de SQL Console connection of GCP with the postgres user and try to execute a simple select * from foo; and the response is Insufficient privilege: 7 ERROR: permission denied for relation

Any suggestion?

I try all the query to grant privileges to a user but no one works...

Thank you, regards

[Yasser Karout (Cloud Platform Support)]

Hello,

I can see you have a Stackoverflow post about this [1], I would advise to keep working on your issue through that since it is better suited for development questions and the format on Stackoverflow will give your question greater visibility. 

[1] https://stackoverflow.com/questions/52243652/gcp-sql-postgres-problem-with-privileges-cant-run-a-query-with-postgres-user

[Alessandro CANDON -ITALY-]

Thank you, 

yes I also solved it..

Regards

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c1ebfd0e-40de-4770-83bd-9fe6ef239925%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Alessandro Candon Application Leader & DevOps Engineer Decathlon IT Italy mobile: +39 344 069 5382 email: alessand...@decathlon.com