<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article FAQ on the Settings the EPM SQL databases use in Endpoint Privilege Manager (EPM) Articles</title>
    <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/faq-on-the-settings-the-epm-sql-databases-use/ta-p/1430145</link>
    <description>&lt;H3&gt;Question&lt;/H3&gt;
&lt;B&gt;Note:&amp;nbsp;&lt;/B&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;Here are the most common issues&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q1:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q2:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q3:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;Why do we need&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;enabled in SQL?&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q4:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;What Permission the&amp;nbsp;&lt;B&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;have and what it needed for?&amp;nbsp;

&lt;H3&gt;Answer&lt;/H3&gt;
&lt;B&gt;&lt;U&gt;A1:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require&amp;nbsp;&lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;only.&lt;BR /&gt;Some examples of the actions performed by our installation that require the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role are as follows:&lt;BR /&gt;&amp;nbsp;
&lt;UL&gt;&lt;LI&gt;Add&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property (for unsafe/external assemblies - see below)&lt;/LI&gt;&lt;LI&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/LI&gt;&lt;LI&gt;Add unsafe assemblies (see below)&lt;/LI&gt;&lt;LI&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/LI&gt;&lt;LI&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;way by using the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role, e.g.:
	&lt;UL&gt;&lt;LI&gt;Temp DB creation during upgrade / DB creation during installation (requires&amp;nbsp;&lt;B&gt;"dbcreator"&lt;/B&gt;&amp;nbsp;Role)&lt;/LI&gt;&lt;LI&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt;&amp;nbsp;Role)&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;BR /&gt;&lt;B&gt;&lt;U&gt;A2:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;The&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property is required for&amp;nbsp;&lt;B&gt;UNSAFE&lt;/B&gt;&amp;nbsp;assemblies (see below). The assemblies should have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission due to the following reasons:

&lt;UL&gt;&lt;LI&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/LI&gt;&lt;LI&gt;The assemblies that do not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission has no access to some built-in .NET&amp;nbsp;framework functionality&lt;/LI&gt;&lt;/UL&gt;
&lt;BR /&gt;&lt;B&gt;&lt;U&gt;A3:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;The value&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;is set to&amp;nbsp;&lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process. I&lt;SPAN style="color: rgb(8, 7, 7);font-family: Arial, sans-serif;font-size: 10.5pt;"&gt;t is needed only for installation/upgrade, and it can be removed later.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;A4:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;&lt;B&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;Permission&amp;nbsp;is&amp;nbsp;to perform backup of EPM DB from within the EPM Admin Console.&amp;nbsp;&amp;nbsp;I&lt;SPAN style="font-size: 10.5pt;font-family: &amp;quot;Arial&amp;quot;,sans-serif;mso-fareast-font-family: Calibri;mso-fareast-theme-font: minor-latin;color: #080707;background: white;mso-ansi-language: #1000;mso-fareast-language: EN-US;mso-bidi-language: AR-SA;"&gt;t is needed only for installation/upgrade, and it can be removed later.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;
&lt;H3&gt;Issue&lt;/H3&gt;
&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;Note:&amp;nbsp;&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="color: #333333;"&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;Here are the most common issues&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require&amp;nbsp;&lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;only.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Some examples of the actions performed by our installation that require the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role are as follows:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&amp;nbsp;
&lt;UL&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property (for unsafe/external assemblies - see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add unsafe assemblies (see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;way by using the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role, e.g.:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;
&lt;UL&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Temp DB creation during upgrade / DB creation during installation (requires&amp;nbsp;&lt;B&gt;"dbcreator"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;The&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property is required for&amp;nbsp;&lt;B&gt;UNSAFE&lt;/B&gt;&amp;nbsp;assemblies (see below). The assemblies should have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission due to the following reasons:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&amp;nbsp;
&lt;UL&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies that do not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission has no access to some built-in .NET&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;framework functionality&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;DIV style="color: rgb(0, 0, 0);font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-style: normal;font-weight: 400;text-align: left;white-space: normal;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Why do we need&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;enabled in SQL&lt;SPAN style="color: #333333;"&gt;?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The value&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;is set to&amp;nbsp;&lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-size: 11pt;"&gt;What Permission the&amp;nbsp;&lt;/SPAN&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 11pt;"&gt;have and what it needed for?&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B style="font-family: Verdana, Helvetica, sans-serif;font-size: small;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;Permission&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;&amp;nbsp;is&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 11pt;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;to perform backup of EPM DB from within the EPM Admin Console.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;
&lt;H3&gt;Steps&lt;/H3&gt;
&lt;TABLE style="width: 1582px;color: rgb(34, 34, 34);font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-style: normal;font-weight: 400;text-align: start;white-space: normal;"&gt;&lt;TBODY&gt;&lt;TR style="width: 30px;"&gt;&lt;TD colspan="1" rowspan="1" style="color: rgb(34, 34, 34);font-family: Arial, Helvetica, sans-serif;font-size: 1em;"&gt;
&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1432px;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD colspan="1" rowspan="1" style="color: rgb(34, 34, 34);font-family: Arial, Helvetica, sans-serif;"&gt;
&lt;DIV id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380_00N2J000009R3kh_div" style="color: rgb(0, 0, 0);font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;Note:&amp;nbsp;&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="color: #333333;"&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;Here are the most common issues&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require&amp;nbsp;&lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;only.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Some examples of the actions performed by our installation that require the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role are as follows:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;						&amp;nbsp;
						&lt;UL&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property (for unsafe/external assemblies - see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add unsafe assemblies (see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;way by using the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role, e.g.:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;
&lt;UL&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Temp DB creation during upgrade / DB creation during installation (requires&amp;nbsp;&lt;B&gt;"dbcreator"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;The&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property is required for&amp;nbsp;&lt;B&gt;UNSAFE&lt;/B&gt;&amp;nbsp;assemblies (see below). The assemblies should have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission due to the following reasons:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;						&amp;nbsp;
						&lt;UL&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies that do not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission has no access to some built-in .NET&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;framework functionality&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;DIV style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Why do we need&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;enabled in SQL&lt;SPAN style="color: #333333;"&gt;?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The value&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;is set to&amp;nbsp;&lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: 11pt;"&gt;What Permission the&amp;nbsp;&lt;/SPAN&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 11pt;"&gt;have and what it needed for?&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B style="font-family: Verdana, Helvetica, sans-serif;font-size: small;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;Permission&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;&amp;nbsp;is&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 11pt;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;to perform backup of EPM DB from within the EPM Admin Console.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;
&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Note: &lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Here are the most common issues&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require &lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;only.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Some examples of the actions performed by our installation that require the &lt;B&gt;"SA"&lt;/B&gt; Role are as follows:&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Add &lt;B&gt;TRUSTWORTHY&lt;/B&gt; property (for unsafe/external assemblies - see below)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Add unsafe assemblies (see below)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;way by using the &lt;B&gt;"SA"&lt;/B&gt; Role, e.g.:&lt;/SPAN&gt;&lt;/FONT&gt;
&lt;UL&gt;&lt;LI&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Temp DB creation during upgrade / DB creation during installation (requires &lt;B&gt;"dbcreator"&lt;/B&gt; Role)&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt; Role)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;The &lt;B&gt;TRUSTWORTHY&lt;/B&gt; property is required for &lt;B&gt;UNSAFE&lt;/B&gt; assemblies (see below). The assemblies should have &lt;B&gt;UNSAFE_ACCESS&lt;/B&gt; permission due to the following reasons:&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have &lt;B&gt;UNSAFE_ACCESS&lt;/B&gt; permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;The assemblies that do not have &lt;B&gt;UNSAFE_ACCESS&lt;/B&gt; permission has no access to some built-in .NET&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;framework functionality&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;DIV&gt;
&lt;P class="MsoNormal"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Why do we need &lt;B&gt;xp_cmdshell&lt;/B&gt; enabled in SQL&lt;SPAN style="color: rgb(51, 51, 51);"&gt;?&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;The value &lt;B&gt;xp_cmdshell&lt;/B&gt; is set to &lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process&lt;FONT color="#333333"&gt;.&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;SPAN style="font-size: 11.0pt;"&gt;What Permission the&amp;nbsp;&lt;/SPAN&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 11.0pt;"&gt;have and what it needed for?&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B style="font-family: Verdana, Helvetica, sans-serif;font-size: small;"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;Permission&lt;/SPAN&gt;&lt;SPAN style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;&amp;nbsp;is&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="font-family: Calibri, sans-serif;font-size: 11pt;"&gt;to perform backup of EPM DB from within the EPM Admin Console.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&amp;nbsp;&lt;/P&gt;
&lt;/DIV&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 04 Aug 2020 16:50:54 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2020-08-04T16:50:54Z</dc:date>
    <item>
      <title>FAQ on the Settings the EPM SQL databases use</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/faq-on-the-settings-the-epm-sql-databases-use/ta-p/1430145</link>
      <description>&lt;H3&gt;Question&lt;/H3&gt;
&lt;B&gt;Note:&amp;nbsp;&lt;/B&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;Here are the most common issues&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q1:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q2:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q3:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;Why do we need&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;enabled in SQL?&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;Q4:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;What Permission the&amp;nbsp;&lt;B&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;have and what it needed for?&amp;nbsp;

&lt;H3&gt;Answer&lt;/H3&gt;
&lt;B&gt;&lt;U&gt;A1:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require&amp;nbsp;&lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;only.&lt;BR /&gt;Some examples of the actions performed by our installation that require the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role are as follows:&lt;BR /&gt;&amp;nbsp;
&lt;UL&gt;&lt;LI&gt;Add&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property (for unsafe/external assemblies - see below)&lt;/LI&gt;&lt;LI&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/LI&gt;&lt;LI&gt;Add unsafe assemblies (see below)&lt;/LI&gt;&lt;LI&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/LI&gt;&lt;LI&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;way by using the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role, e.g.:
	&lt;UL&gt;&lt;LI&gt;Temp DB creation during upgrade / DB creation during installation (requires&amp;nbsp;&lt;B&gt;"dbcreator"&lt;/B&gt;&amp;nbsp;Role)&lt;/LI&gt;&lt;LI&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt;&amp;nbsp;Role)&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;BR /&gt;&lt;B&gt;&lt;U&gt;A2:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;The&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property is required for&amp;nbsp;&lt;B&gt;UNSAFE&lt;/B&gt;&amp;nbsp;assemblies (see below). The assemblies should have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission due to the following reasons:

&lt;UL&gt;&lt;LI&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/LI&gt;&lt;LI&gt;The assemblies that do not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission has no access to some built-in .NET&amp;nbsp;framework functionality&lt;/LI&gt;&lt;/UL&gt;
&lt;BR /&gt;&lt;B&gt;&lt;U&gt;A3:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;The value&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;is set to&amp;nbsp;&lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process. I&lt;SPAN style="color: rgb(8, 7, 7);font-family: Arial, sans-serif;font-size: 10.5pt;"&gt;t is needed only for installation/upgrade, and it can be removed later.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;&lt;U&gt;A4:&lt;/U&gt;&lt;/B&gt;&lt;BR /&gt;&lt;B&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;Permission&amp;nbsp;is&amp;nbsp;to perform backup of EPM DB from within the EPM Admin Console.&amp;nbsp;&amp;nbsp;I&lt;SPAN style="font-size: 10.5pt;font-family: &amp;quot;Arial&amp;quot;,sans-serif;mso-fareast-font-family: Calibri;mso-fareast-theme-font: minor-latin;color: #080707;background: white;mso-ansi-language: #1000;mso-fareast-language: EN-US;mso-bidi-language: AR-SA;"&gt;t is needed only for installation/upgrade, and it can be removed later.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;
&lt;H3&gt;Issue&lt;/H3&gt;
&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;Note:&amp;nbsp;&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="color: #333333;"&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;Here are the most common issues&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require&amp;nbsp;&lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;only.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Some examples of the actions performed by our installation that require the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role are as follows:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&amp;nbsp;
&lt;UL&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property (for unsafe/external assemblies - see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add unsafe assemblies (see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;way by using the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role, e.g.:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;
&lt;UL&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Temp DB creation during upgrade / DB creation during installation (requires&amp;nbsp;&lt;B&gt;"dbcreator"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;The&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property is required for&amp;nbsp;&lt;B&gt;UNSAFE&lt;/B&gt;&amp;nbsp;assemblies (see below). The assemblies should have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission due to the following reasons:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&amp;nbsp;
&lt;UL&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style="margin-left: 1.5em;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies that do not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission has no access to some built-in .NET&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;framework functionality&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;DIV style="color: rgb(0, 0, 0);font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-style: normal;font-weight: 400;text-align: left;white-space: normal;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Why do we need&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;enabled in SQL&lt;SPAN style="color: #333333;"&gt;?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The value&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;is set to&amp;nbsp;&lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-size: 11pt;"&gt;What Permission the&amp;nbsp;&lt;/SPAN&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 11pt;"&gt;have and what it needed for?&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;B style="font-family: Verdana, Helvetica, sans-serif;font-size: small;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;BR /&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;Permission&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;&amp;nbsp;is&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 11pt;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;to perform backup of EPM DB from within the EPM Admin Console.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;
&lt;H3&gt;Steps&lt;/H3&gt;
&lt;TABLE style="width: 1582px;color: rgb(34, 34, 34);font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-style: normal;font-weight: 400;text-align: start;white-space: normal;"&gt;&lt;TBODY&gt;&lt;TR style="width: 30px;"&gt;&lt;TD colspan="1" rowspan="1" style="color: rgb(34, 34, 34);font-family: Arial, Helvetica, sans-serif;font-size: 1em;"&gt;
&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1432px;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD colspan="1" rowspan="1" style="color: rgb(34, 34, 34);font-family: Arial, Helvetica, sans-serif;"&gt;
&lt;DIV id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380_00N2J000009R3kh_div" style="color: rgb(0, 0, 0);font-family: Arial, Helvetica, sans-serif;"&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;Note:&amp;nbsp;&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="color: #333333;"&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;Here are the most common issues&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require&amp;nbsp;&lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;only.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Some examples of the actions performed by our installation that require the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role are as follows:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;						&amp;nbsp;
						&lt;UL&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property (for unsafe/external assemblies - see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Add unsafe assemblies (see below)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;way by using the&amp;nbsp;&lt;B&gt;"SA"&lt;/B&gt;&amp;nbsp;Role, e.g.:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;
&lt;UL&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Temp DB creation during upgrade / DB creation during installation (requires&amp;nbsp;&lt;B&gt;"dbcreator"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt;&amp;nbsp;Role)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;The&amp;nbsp;&lt;B&gt;TRUSTWORTHY&lt;/B&gt;&amp;nbsp;property is required for&amp;nbsp;&lt;B&gt;UNSAFE&lt;/B&gt;&amp;nbsp;assemblies (see below). The assemblies should have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission due to the following reasons:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt;						&amp;nbsp;
						&lt;UL&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The assemblies that do not have&amp;nbsp;&lt;B&gt;UNSAFE_ACCESS&lt;/B&gt;&amp;nbsp;permission has no access to some built-in .NET&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: #333333;"&gt;framework functionality&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;DIV style=""&gt;&lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;Why do we need&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;enabled in SQL&lt;SPAN style="color: #333333;"&gt;?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;B&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;SPAN style="color: #333333;"&gt;The value&amp;nbsp;&lt;B&gt;xp_cmdshell&lt;/B&gt;&amp;nbsp;is set to&amp;nbsp;&lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;SPAN style="font-size: small;"&gt;&lt;SPAN style="font-family: verdana,helvetica,sans-serif;"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;SPAN style="font-size: 11pt;"&gt;What Permission the&amp;nbsp;&lt;/SPAN&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 11pt;"&gt;have and what it needed for?&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B style="font-family: Verdana, Helvetica, sans-serif;font-size: small;"&gt;&lt;SPAN style="color: #333333;"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/SPAN&gt;&lt;BR /&gt; &lt;SPAN id="j_id0:j_id7:j_id8:j_id369:1:j_id372:0:j_id380"&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;Permission&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 14.6667px;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;&amp;nbsp;is&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 11pt;"&gt;&lt;SPAN style="font-family: calibri,sans-serif;"&gt;to perform backup of EPM DB from within the EPM Admin Console.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;
&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Note: &lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Many DBA’s review our database setting and have questions on why and what these settings are used for. &amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Here are the most common issues&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Does Viewfinity user need to be assigned the sysadmin role?&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require &lt;B&gt;DBOwner&lt;/B&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;only.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Some examples of the actions performed by our installation that require the &lt;B&gt;"SA"&lt;/B&gt; Role are as follows:&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Add &lt;B&gt;TRUSTWORTHY&lt;/B&gt; property (for unsafe/external assemblies - see below)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Enable CLR (to allows .NET code to be executed in scope of SQL DB)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Add unsafe assemblies (see below)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Various actions that overall require combinations of various different Roles, that is achieved in the simplest&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;way by using the &lt;B&gt;"SA"&lt;/B&gt; Role, e.g.:&lt;/SPAN&gt;&lt;/FONT&gt;
&lt;UL&gt;&lt;LI&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Temp DB creation during upgrade / DB creation during installation (requires &lt;B&gt;"dbcreator"&lt;/B&gt; Role)&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;etc. (requires&amp;nbsp;&lt;B&gt;"diskadmin"&lt;/B&gt; Role)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;/LI&gt;&lt;/UL&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Currently Viewfinity needs to have Trustworthy setting enabled. Why?&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;The &lt;B&gt;TRUSTWORTHY&lt;/B&gt; property is required for &lt;B&gt;UNSAFE&lt;/B&gt; assemblies (see below). The assemblies should have &lt;B&gt;UNSAFE_ACCESS&lt;/B&gt; permission due to the following reasons:&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have &lt;B&gt;UNSAFE_ACCESS&lt;/B&gt; permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;LI&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;The assemblies that do not have &lt;B&gt;UNSAFE_ACCESS&lt;/B&gt; permission has no access to some built-in .NET&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;framework functionality&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;DIV&gt;
&lt;P class="MsoNormal"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;Why do we need &lt;B&gt;xp_cmdshell&lt;/B&gt; enabled in SQL&lt;SPAN style="color: rgb(51, 51, 51);"&gt;?&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;B&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;The value &lt;B&gt;xp_cmdshell&lt;/B&gt; is set to &lt;B&gt;'TRUE'&lt;/B&gt;, to enable free-disk space check, by the upgrade backup process&lt;FONT color="#333333"&gt;.&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;U&gt;Q:&lt;/U&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;SPAN style="font-size: 11.0pt;"&gt;What Permission the&amp;nbsp;&lt;/SPAN&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-size: 11.0pt;"&gt;have and what it needed for?&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B style="font-family: Verdana, Helvetica, sans-serif;font-size: small;"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;&lt;U&gt;A:&lt;/U&gt;&lt;/SPAN&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&lt;B style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;db_backupoperator&amp;nbsp;&lt;/B&gt;&lt;SPAN style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;Permission&lt;/SPAN&gt;&lt;SPAN style="font-family: Calibri, sans-serif;font-size: 14.6667px;"&gt;&amp;nbsp;is&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="font-family: Calibri, sans-serif;font-size: 11pt;"&gt;to perform backup of EPM DB from within the EPM Admin Console.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class="MsoNormal"&gt;&amp;nbsp;&lt;/P&gt;
&lt;/DIV&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class="MsoNormal" style=""&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 04 Aug 2020 16:50:54 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/faq-on-the-settings-the-epm-sql-databases-use/ta-p/1430145</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-08-04T16:50:54Z</dc:date>
    </item>
  </channel>
</rss>

