private void CreateDatabaseRole(OdsSqlConfiguration odsSqlConfiguration, CloudOdsDatabaseSecurityConfiguration securityConfiguration, ISqlRole role)
{
var databaseName = _cloudOdsDatabaseNameProvider.GetDatabaseName(securityConfiguration.TargetDatabase);
if (!role.IsBuiltinRole)
{
RunSqlProcessOnDatabase(databaseName, odsSqlConfiguration, (connection, configuration) =>
{
_rawSqlConnectionService.ExecuteDdl(connection, role.CreateSql);
});
}
}
public void RenameDatabase(SqlConnection connection, string oldName, string newName)
{
var sql = $"ALTER DATABASE [{oldName}] MODIFY NAME=[{newName}]";
_rawSqlConnectionService.ExecuteDdl(connection, sql);
}
