INF: User Cannot Bind Rule to UDDT Created By Different User

MORE INFORMATION

This behavior is correct and by design. As per SQL Server Books Online, permission to run the sp_bindrule stored procedure on an object, defaults to the owner of that object.

WORKAROUND

To workaround this behavior, use CHECK constraints instead of Rules.

Note that the use of CHECK constraints is the preferred way to restrict the values in a column because CHECK constraints are more concise than Rules. You can only apply one rule to a column, but you can apply multiple CHECK constraints to a column.