public void Generate_RevokeTablePermissionOperation_produce_valid_statement() { var operation = new RevokeTablePermissionOperation("dbo.table", "user", TablePermission.Insert); var sqlGenerator = new ExtendedSqlServerMigrationSqlGenerator(); var sql = sqlGenerator.Generate(new MigrationOperation[] { operation }, "2008").Join(ss => ss.Sql, Environment.NewLine); Assert.Contains("REVOKE INSERT ON dbo.table TO user", sql); }
/// <summary> /// Generate a SQL to remove permission on a table for specified user /// </summary> /// <param name="removeTablePermissionOperation">The operation to produce sql for.</param> public virtual void Generate(RevokeTablePermissionOperation removeTablePermissionOperation) { using (var writer = Writer()) { writer.WriteLine( "REVOKE {0} ON {1} TO {2}", removeTablePermissionOperation.Permission.ToString().ToUpper(), removeTablePermissionOperation.Table, removeTablePermissionOperation.User); this.Statement(writer); } }