Re: PostGres Doubt

Gotcha.  'twas the first time I encountered it, I wasn't expecting it.

Thank you for the clarification.  I hadn't paid attention to that 
paragraph when I read over it.

David

Tom Lane wrote:

>David Ford <david@blue-labs.org> writes:
>  
>
>>heakin=> \z
>>Access privileges for database "heakin"
>>       Table       | Access privileges
>>-------------------+-------------------
>> interviewers      |
>>    
>>
>
>  
>
>>heakin=> grant select,insert,update on interviewers to heakin;
>>GRANT
>>heakin=> \z
>>Access privileges for database "heakin"
>>       Table       | Access privileges 
>>-------------------+--------------------
>> interviewers      | {=,heakin=arwdRxt}
>>    
>>
>
>I take it heakin is the owner of the table in question.  As such,
>he implicitly has all privileges --- the initial null privilege list
>is a shorthand for what you see explicitly in the second case.
>
>The GRANT man page in current development sources has an example about
>this; see the Notes section of
>http://developer.postgresql.org/docs/postgres/sql-grant.html
>
>            regards, tom lane
>  
>