MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

MOSS 2007 Site Access Privileges

  Asked By: Eliseo    Date: Nov 02    Category: MOSS    Views: 764

I am checking to see if anyone has run across a problem with a site losing its
access privileges above read-only. I have a couple of sites that used to have
the full range of group level access - full control, contribute, approve, etc.
However, at some point and I don't know when all these access levels except
read-only have been lost. I can no longer do updates, uploads, creates or
deletes. I even tried accessing the sites on the web server with the service
account and even this user id has read only access to the sites.

The only solution I have found is to create a new site and move all the data to
the new site. Does anyone know of a way to restore the access privileges other
than this method?



3 Answers Found

Answer #1    Answered By: Gerard Randall     Answered On: Nov 02

Did the content database get set to read-only somehow?

Answer #2    Answered By: Audra Mccormick     Answered On: Nov 02

We had a backup solution that didn't unlock the database after
it did its backups. All we had was read-only.

Answer #3    Answered By: Christina Lewis     Answered On: Nov 02

Open powershell on the front end server and set-executionpolicy to either
remotesigned or unrestricted then at step 3

1. Download PowerShell 1.0 to the front-end server and install
2. Save the code below into a file with a ps1 extension
3. Open a command prompt on the front-end server and enter PowerShell by typing
“PowerShell” at the prompt of the directory where you saved the file
4. Call the file with this command “.\filename.ps1”, just type everything
between the quotes, filename is whatever you named the file in step two, above.
5. Make sure to run all the above on a farm administrator account.

[System.Reflection.Assembly]::Load( 'Microsoft.SharePoint, Version="",
culture=neutral, PublicKeyToken= 71e9bce111e9429c' )

$renderXmlPatternAttribute = "RenderXMLUsingPattern"
$siteCollUrl = "http://enter_your_site_URL_here"
$spsite = New-Object Microsoft.SharePoint.SPSite( $siteCollUrl )

$spweb = $spsite.OpenWeb()
$field = $spweb.Fields["Effective Permissions Mask"]
[xml] $xd = New-Object System.Xml.XmlDocument
$xd.LoadXml( $field.schemaXml )
$xe = $xd.get_DocumentElement()

if ( $xe.$renderXmlPatternAttribute -eq $null ) {
$attr = $xd.CreateAttribute( $renderXmlPatternAttribute )
$attr.set_Value( "TRUE" )
$field.schemaXml = $xe.get_OuterXml()

foreach ( $spweb in $spsite.AllWebs) {
for ($i = 0; $i -lt $spweb.Lists.Count; $i++) {
$field = $spweb.Lists[$i].Fields["Effective Permissions Mask"]
[xml] $xd = New-Object System.Xml.XmlDocument
$xd.LoadXml( $field.schemaXml )
$xe = $xd.get_DocumentElement()

if ( $xe.$renderXmlPatternAttribute -eq $null ) {
"$spweb - $($spweb.Lists[$i])"
$attr = $xd.CreateAttribute( $renderXmlPatternAttribute )
$attr.set_Value( "TRUE" )
$field.schemaXml = $xe.get_OuterXml()

Didn't find what you were looking for? Find more on MOSS 2007 Site Access Privileges Or get search suggestion and latest updates.