Re: [HACKERS] grant broken - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] grant broken
Date
Msg-id 34B7A311.C35B4454@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] grant broken  (Peter T Mount <psqlhack@maidast.demon.co.uk>)
Responses Re: [HACKERS] grant broken
List pgsql-hackers
> > Can you give me a test case?  Is it \z on an empty database, or does a
> > table have to have a specific permissoin?
>
> It's a test database, with a single table in it, and two users (the DBA,
> and a normal user).
>
> One of the methods in JDBC's DatabaseMetaData returns details about the
> rights granted on the database, so to test the method, I was setting up
> the normal user with update rights to the table, so I had something to
> work on.
>
> The backend simply dies when ever the grant statement is entered
> correctly.

If I understood the test case you published, you are specifying to the grant
command the database "test", not a table within the database. The man page for
grant is not very specific, but is this supposed to work?

                                            - Tom


pgsql-hackers by date:

Previous
From: Goran Thyni
Date:
Subject: Re: [HACKERS] DefaultHost
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: subselects