Re: [ADMIN] can't revoke users

2008-02-11 Thread Scott Cotton
This is on 7.4 running on CentOS. I think I've narrowed the issue down. The problem is in some cases the permissions for the bad users were granted by one of the bad users. So even if I'm logged in as the table owner, I can't revoke privileges on a user that was granted privileges by another u

Re: [ADMIN] can't revoke users

2008-02-11 Thread Peter Koczan
On Feb 8, 2008 6:01 PM, Scott Cotton <[EMAIL PROTECTED]> 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 > h

[ADMIN] can't revoke users

2008-02-11 Thread Scott Cotton
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) u