INF: User Cannot Bind Rule to UDDT Created By Different User (198851)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q198851 SUMMARY
If a user (this also includes the system administrator [sa]) tries to bind a rule to a user-defined data type (UDDT) that was created by a different user, the following error message occurs:
You do not own a data type with that name.
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.
| Modification Type: | Major | Last Reviewed: | 10/17/2003 |
|---|
| Keywords: | kbinfo KB198851 |
|---|
|