INF: Effect of Permissions Additions/Deletions on SYSPROTECTS

ID Number: Q47602

1.00 1.10 1.11 4.20

OS/2

Summary:

The following information describes how SYSPROTECTS adds or modifies

rows when permissions are granted or revoked.

More Information:

SYSPROTECTS 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 reference words: 1.00 1.10 1.11 4.20 Transact-SQL permission