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