Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group