Revoke missing user

From: "Robert Fitzpatrick" <robert(at)webtent(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Revoke missing user
Date: 2003-04-25 01:58:07
Message-ID: 000401c30ace$21171f10$0b01a8c0@columbus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I removed a user from PostgreSQL that had privileges on some tables, now
the access privileges shows just the former user number. When I try:

revoke all on allergies from 104;

I get:

ERROR: parser: parse error at or near "104" at character 30

I even try creating a user named 104, same result. How can I revoke
those privileges?

--
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Kirkwood 2003-04-25 02:03:24 Re: Solaris
Previous Message elein 2003-04-25 01:48:47 Re: Storing sequence numbers for later use