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