Message-ID: <40925695.8060908@deg.cc>
Date: Fri, 30 Apr 2004 09:37:25 -0400
From: Pallav Kalva <pkalva@deg.cc>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-sql@postgresql.org
Subject: Re: Permissions not working
References: <Pine.LNX.4.33.0404291522430.10983-100000@css120.ihs.com>
	<40917768.8040107@deg.cc> <17807.1083280047@sss.pgh.pa.us>
In-Reply-To: <17807.1083280047@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Tom Lane wrote:

>Pallav Kalva <pkalva@deg.cc> writes:
>  
>
>>I have a database for ex: 'ups' and it was owned previously by 
>>'postgres(superuser)' but now i have changed the ownership to new user 
>>'ups' all the tables are owned by these user 'ups'.
>>    
>>
>
>That isn't a supported operation.  How did you do it exactly?  I suspect
>that you got it wrong somehow ...
>
 
   Sorry, I wasnt clear on this. First I created a database called 'ups' 
and made user 'ups' as its owner. Then
   I dumped the database from backup, the dumped database backup was 
owned by 'postgres ' user but all the
   tables in this database are owned by 'ups' user.


>
>  
>
>>I dont want  user 'test' to access any tables from the 'ups' 
>>database, i tried revoking permissions it still doesnt work.
>>    
>>
>
>What did you revoke?  What does psql's "\z" command show for the problem
>tables?
>
>			regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>  
>
Here is the output from the \z . I tried to revoke all the privileges 
from the PUBLIC and user 'test'.

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)