BUG: sp_helprotect May Give Redundant Information

ID: Q93341

The information in this article applies to:

Microsoft SQL Server version 4.2 for OS/2
Microsoft SQL Server version 4.2x


BUG# OS/2: 1551 (4.2)
       NT:  879 (4.2)

SYMPTOMS

The results of executing the system stored procedure, sp_helprotect, on a table with more than 100 columns will indicate that the users who have been granted "delete" permission on the table, have "delete" permission on the table as well as "delete" permission on the columns beyond column 100.

For instance, sp_helprotect "mytable" will give the following results, where "mytable" is a 101 column table, with the 101st column named as c1. Note that "delete" permission on the table has been granted to the group "public".


   Type   Action   User   Column
   -----------------------------
   Grant  Delete   public  all
   Grant  Delete   public  c1

In the above results, the second row is redundant. Note that if there are 102 columns in the table, there would be an extra row in the results. The same redundant behavior is seen for the insert permissions granted to users.

WORKAROUND

Ignore the superfluous rows. For actions like "delete" and "insert", the only valid rows from sp_helprotect are those where the "column" information is "all".

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server versions 4.21 and 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords : kbprg kbbug4.20 kbbug4.20a kbbug4.21 SSrvServer SSrvWinNT
Version : 4.2 | 4.21 4.21a
Platform : OS/2 WINDOWS
Issue type :