Re: [Emerald] Change object owner in MSSQL

Dale E. Reed Jr. ( (no email) )
Tue, 09 Feb 1999 13:09:15 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] RadLog Violation of PRIMARY KEY constraint"
Next message: Ed Miller: "Re: [Emerald] DOH!"
Maybe in reply to: Griswold Wayne: "[Emerald] Change object owner in MSSQL"

Griswold Wayne wrote:
>
> We are trying to remove a user (Drop) from the MSSQL6.5 Enterprise
> Server Manager, however we receive the following message "You cannot drop
> the selected login ID because that login ID owns objects in one or more
> databases." Upon further poking around, it appears that the user in
> questions "owns" the following objects: History, RadiusUsers, and
> VerifyNTMUser.
> How do I edit those objects to change the owner so that I can Drop the
> login ID in question?

I don't know if you can. The owner of the object is the person who
created
it (typically dbo, the database owner). You would probably have to drop
the objects and re-create them as dbo.

-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html

Previous message: Dale E. Reed Jr.: "Re: [Emerald] RadLog Violation of PRIMARY KEY constraint"
Next message: Ed Miller: "Re: [Emerald] DOH!"
Maybe in reply to: Griswold Wayne: "[Emerald] Change object owner in MSSQL"