SQL Server - Duplicate Table Permissions: What does a "Null" grantor signify? -
We have recently set table-level permissions on the SQL Server database, but there is a problem:
< P> There are two permissions lines for each permit on the table (for a single user) One of these lines is a zero grantor (nothing has been checked on the permissions), the second has "dbo" as the approval There are permissions in the form that we have just established.What could be the duplicate permissions with the Null grantor? Any ideas?
 Two permissions lines are usually displayed when a database principal  except for dB  Has been detected because it has allowed the  permission  with permission to cancel all the principals who have been granted permission, then it has been canceled. 
 I have not seen any examples of a donor I doubt that tap granter has a canceled code  Results  with Nudan. Try clearing any of these set, if appropriate, then give them a try from the debo and see if the blue lines are going out. If they do then I do not worry about it further; If they do not do this then you can get a much more serious corruption. 
Comments
Post a Comment