Securing the ExtendedProps Table

  • Article

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.

Ee810450.note(en-US,CS.20).gifNote

  • 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.