Securing the ExtendedProps Table

The following table lists the permissions a given account should have for the ExtendedProps table, which resides in the MSCS_Admin database. Use SQL Server Enterprise Manager to set these permissions.

Note

• If your site is based on COM, the default anonymous account in IIS is IUSR_<computername>. If your site is based on ASP.NET, the default anonymous account is ASPNET.

Columns	IUSR or ASPNET	IWAM	Service accounts	COM+ identity accounts	System administrators	Business managers
s_ResourceType	No access	No access	No access	No access	Select Update	No access
s_PropertyName	No access	No access	No access	No access	Select Update	No access
f_IsConnStr	No access	No access	No access	No access	Select Update	No access
f_IsHidden	No access	No access	No access	No access	Select Update	No access
f_IsSimpleList	No access	No access	No access	No access	Select Update	No access
s_Description	No access	No access	No access	No access	Select Update	No access
i_Vartype	No access	No access	No access	No access	Select Update	No access
s_Value	No access	No access	No access	No access	Select Update	No access
s_DisplayName	No access	No access	No access	No access	Select Update	No access

Copyright © 2005 Microsoft Corporation.
All rights reserved.