Microsoft KB Archive/47602

From BetaArchive Wiki

INF: Effect of Permissions Additions/Deletions on SYSPROTECTS

ID: Q47602

The information in this article applies to:

  • Microsoft SQL Server for OS/2, version 4.2


The following information describes how SYSPROTECTS adds or modifies rows when permissions are granted or revoked.


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 query words: Transact-SQL permission

Keywords : kbprg SSrvServer
Version : 4.2
Platform : OS/2
Issue type :

Last Reviewed: March 9, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.