Horton

Re: [SPAM] Re: Permissions not working

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pallav Kalva <pkalva@deg.cc>
Cc: Peter Eisentraut <peter_e@gmx.net>, "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-sql@postgresql.org
Date: 2004-05-03T14:23:23Z
Lists: pgsql-sql 
Pallav Kalva <pkalva@deg.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