RE: FN-FORUM: Delete SQL Server User

date posted 19th March 2006 18:56

It's generally recommended to not give the ownership of objects to
anything other than dbo. Then you don't have this problem in the future.

Cheers
Andy=20

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
Stephen Tierney
Sent: Sunday, March 19, 2006 6:56 PM
To: Andy Macnaughton-Jones
Subject: RE: FN-FORUM: Delete SQL Server User


Aye you need to change the owner to somebody other than the user you are
trying to delete. There is a stored procedure to show you all these
objects I can't remember what it is atm sp_helplogins ? You could always
revoke the user login using sp_revokelogin or sp_droplogin.

Hope this helps.

Stephen

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Kevan
Froud
Sent: 17 March 2006 10:58
To: FN-FORUM / [EMAIL REMOVED]
Subject: RE: FN-FORUM: Delete SQL Server User


17 March 2006 01:29 Craig wrote:
> Anyone know how to delete a database user from an SQL 2000 database=20
> when you get a dialogue warning saying you can't remove the user=20
> because it owns objects? I can't see where

Hi Craig
I had the same problem once and IIRC I found the users UID in the
sysObjects table, changed it to the dbo uid (usually 1) and problem
solved.

HTH
Kevan


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html