Re: Strange Grant behavior in postgres 8.3

From: Schwaighofer Clemens <clemens(dot)schwaighofer(at)tequila(dot)jp>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange Grant behavior in postgres 8.3
Date: 2009-02-18 09:54:52
Message-ID: fed954960902180154p168fc536l4718dcaa893e1fe4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 18, 2009 at 17:42, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Tue, Feb 17, 2009 at 9:20 PM, Clemens Schwaighofer
> <clemens(dot)schwaighofer(at)tequila(dot)jp> wrote:
>
>> But yesterday I run in some issues with table ownership and thought if I
>> just give the user all rights for the DB, he should have all rights to
>> the tables too.
>
> Try granting select on a database and you will get this:
>
> grant select on database smarlowe to stan;
> ERROR: invalid privilege type SELECT for database
>
> OTOH,
>
> grant connect on database smarlowe to stan;
> GRANT
>
> But even easier is to use the db owner as the ROLE instead of as a
> user, and just
>
> alter group guywhoownsthedb add user guywhodoesnt;

Thats a very good idea. Probably easier to handle, if you need to add
just another user or so.

--
[ Clemens Schwaighofer -----=====:::::~ ]
[ IT Engineer/Manager ]
[ E-Graphics Communications, TEQUILA\ Japan IT Group ]
[ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7703 Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.jp ]

Advertising Age Global Agency of the Year 2008
Adweek Global Agency of the Year 2008

This e-mail is intended only for the named person or entity to which
it is addressed and contains valuable business information that is
privileged, confidential and/or otherwise protected from disclosure.
Dissemination, distribution or copying of this e-mail or the
information herein by anyone other than the intended recipient, or
an employee or agent responsible for delivering the message to the
intended recipient, is strictly prohibited. All contents are the
copyright property of TBWA Worldwide, its agencies or a client of
such agencies. If you are not the intended recipient, you are
nevertheless bound to respect the worldwide legal rights of TBWA
Worldwide, its agencies and its clients. We require that unintended
recipients delete the e-mail and destroy all electronic copies in
their system, retaining no copies in any media.If you have received
this e-mail in error, please immediately notify us via e-mail to
disclaimer(at)tbwaworld(dot)com(dot) We appreciate your cooperation.

We make no warranties as to the accuracy or completeness of this
e-mail and accept no liability for its content or use. Any opinions
expressed in this e-mail are those of the author and do not
necessarily reflect the opinions of TBWA Worldwide or any of its
agencies or affiliates.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Rahman 2009-02-18 10:28:16 Re: Download link for 'Bristlecone'
Previous Message Richard Huxton 2009-02-18 09:48:40 Re: could not write block