Re: [HACKERS] grant broken

Thomas Lockhart <lockhart@alumni.caltech.edu>

From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: Peter T Mount <psqlhack@maidast.demon.co.uk>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>, pgsql-hackers@postgresql.org
Date: 1998-01-10T16:34:25Z
Lists: 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