Securing the Resources Table

  • Article

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

Ee823709.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_DisplayName
 Select Select Select Select Select
Update		 Select 
s_Description
 Select Select Select Select Select
Update		 Select 
s_Type
 Select Select Select Select Select
Update		 Select 
f_IsGlobal
 Select Select Select Select Select
Update		 Select 
f_ResourceFlags
 Select Select Select Select Select
Update		 Select 
s_ProgIDSnapIn
 Select Select Select Select Select
Update		 Select 
s_Computer
 Select Select Select Select Select
Update		 Select 
i_Status
 Select Select Select Select Select
Update		 Select 
f_PupFlags
 Select Select Select Select Select
Update		 Select 
s_ProgIDPUP
 Select Select Select Select Select
Update		 Select 
s_PupParam1
 Select Select Select Select Select
Update		 Select 
s_PupParam2
 Select Select Select Select Select
Update		 Select 
s_PupParam3
 Select Select Select Select Select
Update		 Select

Copyright © 2005 Microsoft Corporation.
All rights reserved.