Re: [Revoke] cannot revoke the permission of "some User".... - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [Revoke] cannot revoke the permission of "some User"....
Date
Msg-id Pine.LNX.4.30.0108301635470.679-100000@peter.localdomain
Whole thread Raw
In response to [Revoke] cannot revoke the permission of "some User"....  ("Wong Ka Ho Matthew" <mattheww@skytelemedia.com>)
List pgsql-general
Wong Ka Ho Matthew writes:

>         mytable | {"=","28=arw","34=arw","36=arw","40=arw","42=arw","cgi=arw"}
>
>     i guess those numeric thingy is kinda object id of a user, and i've deleted
>     the user b4 i revoke the permission of that user from "mytable".
>
>     is it possible for me to remove those 28, 34 & 36?

Better recreate the users with these ids, then revoke, then drop the
users.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: RE: RFC: PostgreSQL and MySQL comparison.
Next
From: Larry Rosenman
Date:
Subject: Re: --enable-syslog and Solaris 7