Peter Eisentraut wrote:
Pallav Kalva wrote:
I tried both database privileges and table privileges (all and
select) it still doesnt work. Not sure
what is wrong here, I tried logging in as both postgres and usps user
and both them doesnt work.
What about all those groups that have privileges? Please post the output of \z when you try a revoke so we can verify what's going on.
here is the output. This is the same output, this output doesnt change at all.
usps=> \z citystate_alias
Access privileges for database "usps"
Schema | Table | Access privileges
--------+-----------------+-----------------------------------------------------------------------------------------------------------------------
public | citystate_alias | {postgres=a*r*w*d*R*x*t*/postgres,=r/postgres,usps=arwdRxt/postgres,"group 100=r/usps","group ea_development=r/usps"}
(1 row)
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
