Re: [SPAM] Re: Permissions not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pallav Kalva <pkalva(at)deg(dot)cc>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, "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 14:23:23
Message-ID: 13033.1083594203@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Pallav Kalva <pkalva(at)deg(dot)cc> 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 revokes privileges
directly associated with the database object, which are the rights to
create new schemas and temp tables within the database.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pallav Kalva 2004-05-03 15:06:01 Re: [SPAM] Re: Permissions not working
Previous Message Pallav Kalva 2004-05-03 13:33:01 Re: [SPAM] Re: Permissions not working