On Feb 8, 2008 6:01 PM, Scott Cotton <scott.cotton@xxxxxxxxx> wrote: > I have a database that I dropped some users on. However, when doing dumps > and restores, it became clear that these users were still being referenced > by sysid. So I created new users and assigned them the sysids of the users I > had dropped. > > So now I went to revoke the privileges for the new (temp) users. However, > some tables I can revoke the users and some I cannot. > I also tried to drop one of the new users I created and it created the same > situation as before, where the user still shows up with priveleges, but > instead of listing a name it lists a sysid. I've had to deal with stuff like this before. What exactly are the errors are you getting, and what version of PostgreSQL are you running? Peter ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match