Azure Flexible Postgres: Configuring auth_query refering to pg_shadow table in pgbouncer throws "permission denied for table pg_shadow"

Channabasawa Nagur 0

Hi,

I am configuring auth_query for pgbouncer authentication.

auth_query is in turn referring to pg_shadow running below query

Select usename, 
  passwd 
from 
  pg_shadow

this throws error: "permission denied for view pg_shadow"

is there a way to give access to this table for my user?

GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-06-23T13:48:44.04+00:00

Hi @Channabasawa Nagur Looks like this is a duplicate of this https://learn.microsoft.com/en-us/answers/questions/1316636/azure-flexible-postgres-configuring-auth-query-ref

Regards

Geetha
Channabasawa Nagur 0 Reputation points

2023-06-23T13:53:37.09+00:00

Hi @GeethaThatipatri-MSFT could you please verify the link shared? it is pointing to the same question.

Thanks,

Channa

Your answer