Monday, February 20, 2012

Permission denied trying to delete user

Hi,
iam ratnesh and want to delet the user which is created in database, it gives me error that selected cannot be droped because the user owns object, pls help me to resolve the problem.

Regards[First use sp_changeobjectowner to convert the ownership to dbo from that user and then drop the unwanted user.

No comments:

Post a Comment