Re: can't revoke users

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux