The information in this article applies to:
SUMMARYThe following information describes how SYSPROTECTS adds or modifies rows when permissions are granted or revoked.
MORE INFORMATIONSYSPROTECTS has a unique clustered index on User-ID, Object-ID, and Permission. If a second GRANT or REVOKE is made for the same Permission on the same Object/User combination, the existing row is replaced. If the particular combination of User, Object, and Permission does not already exist in SYSPROTECTS, a new row is added. Additional query words: Transact-SQL permission Keywords : kbprg SSrvServer |
Last Reviewed: March 9, 1999 |