Securing the Sites Table

  • Article

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

Ee810472.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_SiteID
 Select Select Select Select Select
Update		 Select 
s_Name
 Select Select Select Select Select
Update		 Select 
s_Description
 Select Select Select Select Select
Update		 Select 
i_Status
 Select Select Select Select Select
Update		 Select 
d_DateCreated
 Select Select Select Select Select
Update		 Select 
d_DateModified
 Select Select Select Select Select
Update		 Select

Copyright © 2005 Microsoft Corporation.
All rights reserved.