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.
Any ideas?
Thanks,
Scott