From: | Pallav Kalva <pkalva(at)deg(dot)cc> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SPAM] Re: Permissions not working |
Date: | 2004-05-03 18:28:19 |
Message-ID: | 40968F43.1060305@deg.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | H.J. Sanders | 2004-05-03 19:36:52 | start |
Previous Message | Peter Eisentraut | 2004-05-03 17:55:56 | Re: [SPAM] Re: Permissions not working |