Thread: [Revoke] cannot revoke the permission of "some User"....

[Revoke] cannot revoke the permission of "some User"....

From
"Wong Ka Ho Matthew"
Date:
Hello all,
 
    when i use the "\dp" to view the permission of "mytable":
 
        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?
 
    thanks in advance.
 
---
matthew

Re: [Revoke] cannot revoke the permission of "some User"....

From
Peter Eisentraut
Date:
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