User can't be deleted because it has granted/denied permissions on objects
- From: "Tim Greenwood" <tim_greenwood AT yahoo DOT com>
- Date: Thu, 9 Aug 2007 09:07:07 -0700
How to determine what it has granted/denied? I've been tasked with
restoring a 3rd parties database and we're cleaning up some things including
the plethora of sql login/users and going to all domain based groups. I
cannot delete this one user. I've transferred all objects owned by it to
another user but still get this message.
I'm stuck..
Thanks for any insight here!
.
- Follow-Ups:
- Re: User can't be deleted because it has granted/denied permissions on objects
- From: Russell Fields
- Re: User can't be deleted because it has granted/denied permissions on objects
- Prev by Date: Re: Credentials not being passed with remote access
- Next by Date: Determining windows grouop membership of a SQL login
- Previous by thread: job access
- Next by thread: Re: User can't be deleted because it has granted/denied permissions on objects
- Index(es):