private static void GrantPlatformPermissions(PlatformDatabaseConfiguration platformConfiguration)
{
try {
ConfigurationManagerUtils.ExecuteStatements(
platformConfiguration.ElevatedRuntimeDatabaseConfiguration(),
GetGrantPlatformPermissionsStatements(platformConfiguration.RuntimeUser));
} catch { }
}
public override string GenerateSetupScript()
{
NormalizeAllUsers();
PlatformDatabaseConfiguration conf = (PlatformDatabaseConfiguration)uiConfiguration;
//for P10 the setup script is going to be generated by the conf tool to avoid duplication
string setupScript = ReplaceTokens(ReadScriptFile(StreamForSetupScriptFile));
return(setupScript);
}
/// <summary>
/// Replaces known tokens in the given statement
/// </summary>
/// <param name="statement"></param>
/// <returns></returns>
private string ReplaceTokens(string statement)
{
PlatformDatabaseConfiguration conf = (PlatformDatabaseConfiguration)uiConfiguration;
const string TAG_LOGUSERNAME = "******";
const string TAG_LOGPASSWORD = "******";
var tokenMap = new Dictionary <string, string>()
{
{ TAG_LOGUSERNAME, conf.LogUser },
{ TAG_LOGPASSWORD, conf.LogPassword },
};
return(ConfigurationManagerUtils.ReplaceTokens(conf, statement, tokenMap));
}
public override string ProcessStatement(string statement)
{
PlatformDatabaseConfiguration config = (PlatformDatabaseConfiguration)uiConfiguration;
statement = statement.Trim();
if (config.Unicode)
{
statement = _varcharRe.Replace(statement, "$1nvarchar$2$3");
statement = _clobRe.Replace(statement, "$1nclob$2");
statement = _textRe.Replace(statement, "$1ntext$2");
}
return(statement);
}
private void GrantPlatformDatabaseUserPermissions(PlatformDatabaseConfiguration dbConfig)
{
var configRuntime = dbConfig.ElevatedRuntimeDatabaseConfiguration();
var configMaster = ConfigurationManagerUtils.ConfigurationToMaster(dbConfig);
var authType = dbConfig.AuthenticationMode;
// Create User
if (ConfigurationManagerUtils.NeedsCreate(configMaster, configRuntime, dbConfig.AdminUser))
{
if (authType == AuthenticationType.Windows_Authentication)
{
ConfigurationManagerUtils.AddIntegratedAuthLogin(configRuntime, dbConfig.AdminUser);
}
else
{
ConfigurationManagerUtils.AddDBAuthLogin(configMaster, dbConfig.AdminUser, dbConfig.AdminPassword);
}
}
if (ConfigurationManagerUtils.NeedsPermissionsForAdmin(configRuntime, dbConfig.AdminUser))
{
ConfigurationManagerUtils.AddAdminPermissions(configRuntime, dbConfig.AdminUser);
}
if (ConfigurationManagerUtils.NeedsCreate(configMaster, configRuntime, dbConfig.RuntimeUser))
{
if (authType == AuthenticationType.Windows_Authentication)
{
ConfigurationManagerUtils.AddIntegratedAuthLogin(configRuntime, dbConfig.RuntimeUser);
}
else
{
ConfigurationManagerUtils.AddDBAuthLogin(configMaster, dbConfig.RuntimeUser, dbConfig.RuntimePassword);
}
}
if (ConfigurationManagerUtils.NeedsPermissionsForReadWrite(configRuntime, dbConfig.RuntimeUser, dbConfig.AuthenticationMode))
{
ConfigurationManagerUtils.AddReadWritePermissions(configRuntime, dbConfig.RuntimeUser);
}
try {
ConfigurationManagerUtils.AddRuntimePermissionsAfterUpgradeScript(configRuntime, dbConfig.RuntimeUser);
} catch { }
GrantPlatformPermissions(dbConfig);
}
public override string GenerateSetupScript()
{
NormalizeAllUsers();
PlatformDatabaseConfiguration conf = (PlatformDatabaseConfiguration)uiConfiguration;
//for P10 the setup script is going to be generated by the conf tool to avoid duplication
StringBuilder sb = new StringBuilder(ReadScriptFile(StreamForSetupScriptFile));
sb.Replace(TAG_CATALOG, conf.Catalog);
sb.Replace(TAG_ADMINUSERNAME, conf.AdminUser);
sb.Replace(TAG_ADMINPASSWORD, conf.AdminPassword);
sb.Replace(TAG_RUNTIMEUSERNAME, conf.RuntimeUser);
sb.Replace(TAG_RUNTIMEPASSWORD, conf.RuntimePassword);
sb.Replace(TAG_LOGUSERNAME, conf.LogUser);
sb.Replace(TAG_LOGPASSWORD, conf.LogPassword);
sb.Replace(TAG_AUTH, conf.AuthenticationMode == AuthenticationType.Windows_Authentication ? "windows" : "sql");
return(sb.ToString());
}
