Re: help (maybe i'm a little stupid)

Steve Brett wrote:
> i've just tested this and it seems to be the case.
>
> i created a test db, then a test table, then a test user called fred.
>
> then i did a revoke all on fred and then granted select.
>
> then i connected as fred and tried to create a table and the table was
> created.
>
> i wouldn't have expected this to be the case ...

Yes, this has been an admin failing for many releases now, finally to be
fixed in 7.3.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026