Re: can't "grant all on database..."

Ok, I give up.

I've created a database called "Inflight" using user "fc".  I want to
create a second user called "johndoe" and grant him all priviledges on
the "Inflight" database and then restrict him access to certain
IPAddress using the pg_hba.conf file.

Anyone know the magic words?


Stephan Szabo wrote:

>On Wed, 18 Jun 2003, Travis Hume wrote:
>
>
>
>>Ok, using "Inflight" instead of Inflight sems to work, except the user
>>luser still doesn't have any privileges.
>>
>>grant all on database "Inflight" to luser;
>>
>>returns:
>>
>>    GRANT
>>
>>But if I then "psql Inflight luser", I can't do anything including
>>simple selects against the Inflight database.
>>
>>
>
>The database permissions control whether or not you can create schemas and
>temporary objects I think looking at the grant page.  That doesn't give
>permission on other objects in the database, you need to grant permissions
>to those separately.
>
>
>
>>Travis Hume wrote:
>>
>>
>>
>>>The dbname is "Inflight", and I did think it was strange the the error
>>>msg called it "inflight".
>>>What is this "case folding of unquoted names" you speak of?  Do I need
>>>to quote my dbname?  Anything else?
>>>
>>>
>
>For objects made with double quotes and mixed case (I believe this applies
>to createdb) you need to always refer to them with double quotes.
>
>
>