Securing the ResourceProps Table

  • Article

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

Ee823750.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 
i_ResourceID
 Select Select Select Select Select
Update		 Select 
s_PropertyName
 Select Select Select Select Select
Update		 Select 
f_IsConnStr
 Select Select Select Select Select
Update		 Select 
f_IsHidden
 Select Select Select Select Select
Update		 Select 
f_IsSimpleList
 Select Select Select Select Select
Update		 Select 
s_Description
 No access No access No access No access Select
Update		 No access 
i_Vartype
 Select Select Select Select Select
Update		 Select 
s_Value
 Select Select Select Select Select
Update		 Select 
s_DisplayName
 No access No access No access No access Select
Update		 No access

Copyright © 2005 Microsoft Corporation.
All rights reserved.