User Defined Datatypes

[Toni Eibner]

Is it possible to change the owner of a User Defined Dataype? I've
recently had to change the owner of one of my databases and the
tables from a specific user to 'dbo'. The UDD's are the only objects
I am unable to change the ownership of.

Any suggestions anyone?
Thanks for any advice!
Toni Eibner

[Toni]

It can be changed by finding out the UID of the user to change ownership to,
then:
UPDATE SYSTYPES SET UID=<NEW UID> WHERE NAME=&#34;<DATATYPE NAME>&#34;




On 1/5/99 7:48:12 AM, Toni Eibner wrote:
> Is it possible to change the owner of a User Defined Dataype?
> I&#39;ve
recently had to change the owner of one of my databases and
> the
tables from a specific user to &#39;dbo&#39;. The UDD&#39;s are the
> only objects
I am unable to change the ownership of.

Any suggestions
> anyone?
Thanks for any advice!
Toni Eibner