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 privile
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
usps=# revoke all on database usps from public,test;
You seem to think that that translates to revoking all privileges to
objects within the database. It doesn't. It only revokes privileges
directly associated with the database object, which are the rights to
create new schemas and temp tab
Pallav Kalva <[EMAIL PROTECTED]> writes:
> I did the same, still doesnt work . Here is the sequence of what I did .
> usps=# revoke all on database usps from public,test;
You seem to think that that translates to revoking all privileges to
objects within the database. It doesn't. It only revoke
Peter Eisentraut wrote:
Pallav Kalva wrote:
Also here is the privileges information from information_schema
tables. Is there a way to REVOKE these
privileges ?
You need to log in as the user that has granted the privilege you want
to revoke. In this case, log in as postgres and do REVOKE