Unanswered: SQL Server 7 to 2000 Migration Problem
I have successfully migrated a SQL Server 7 Database Server to SQL Server 2000 Server. All the databases were migrated properly.
A strange thing happens when I create a table in one of those migrated database and assign SELECT permission to PUBLIC. The SELECT permission disappears from the table. I am not able to assign it to the PUBLIC.
The problem is if I give GRANT permission to any USER on any TABLE, the permissioning takes place, but SQL Server does not put any entry in the SYSPROTECTS table. That means the USER gets the permission to access the TABLE, but you don't see the permission entry in the SYSPROTECTS table. So, in the ENTERPRISE MANAGER also you don't see a tick mark.
In short, I am able to give permission to the user but I don't really get to see who got permission to access what.