cyrilgdn / terraform-provider-postgresql

Terraform PostgreSQL provider
https://www.terraform.io/docs/providers/postgresql/
Mozilla Public License 2.0
376 stars 194 forks source link

Also check inherited roles #271

Open thomasboussekey opened 1 year ago

thomasboussekey commented 1 year ago

The PostgreSQL role used by the TERRAFORM provider can be owner of PostgreSQL owner of database or schema through role granted.

In this PR, SQL checks are enriched by an UNION ALL in order to query the ownership through granted roles.

thomasboussekey commented 1 year ago

Hello @cyrilgdn ,

Thanks for the branch refresh operation.

I tried to launch test form my laptop, but I'm already using golang 1.19 on my computer, and I encounter error because the Makefile script uses golang 1.18.

Do you have a procedure for using docker container or any similar tool?

Thanks in advance, Thomas