Enable or Disable Security for a Repository

To enable or disable the security

We recommend to enable Security for the repositories while working in the Production environment.

1. Connect to Farm database.

2. Query the properties column for the specified repository, as shown in following code snippet:

   SELECT Properties, * FROM SKRepository

   WHERE Name = 'RepositoryName'

   It will display the following record for the specified repository. Select the properties column value and copy it:

   <properties>

   <property key="spexplorerDisplayLimit"><![CDATA[0]]></property>

   <property ey="sourceelements"><![CDATA[WORKFLOWELEMENTS\Default]]></property>

   <property key="fromemail"><![CDATA[admin@domain.com]]></property>

   <property key="toemail"><![CDATA[admin@domain.com]]></property>

   <property key="alertuser"><![CDATA[False]]></property>

   <property key="filewatcher"><![CDATA[]]></property>

   <property key="enablesecurity"><![CDATA[True]]></property>

   <property key="enablewebparts"><![CDATA[True]]></property>

   <property key="isadminconfigured"><![CDATA[True]]></property>

   <property key="isThemeEnabled"><![CDATA[True]]></property>

   <property key="theme"><![CDATA[Default]]></property>

   <property key="isDMSEnabled"><![CDATA[False]]></property>

   <property key="AutoMapActiveDirectoryProviders"><![CDATA[True]]></property>

   </properties>

3. Modify the property value for enablesecurity property to ‘True/False’.

4. Update the column value for the specified repository.

   UPDATE SKRepository

   SET Properties = 'Modified properties'

   WHERE Name = 'RepositoryName'

5. Do an IISRESET.