Can't remove user from role

I have a user in a database role that I cannot remove from the role.
If I go into the user's properties and deselect the role, click OK,
then go back in, the role is still checked.
I've tried to remove them via sp_droprolemember without success.
I am able to add and drop the user from other roles, though, and I'm
able to add/drop other users to the same role.
How do I drop them from the role?
Using: SQL Server 2005 EnterpriseWhat error message did you get when you tried to remove it from the role?
Linchi
"cbtechlists@.gmail.com" wrote:
> I have a user in a database role that I cannot remove from the role.
> If I go into the user's properties and deselect the role, click OK,
> then go back in, the role is still checked.
> I've tried to remove them via sp_droprolemember without success.
> I am able to add and drop the user from other roles, though, and I'm
> able to add/drop other users to the same role.
> How do I drop them from the role?
> Using: SQL Server 2005 Enterprise
>|||Hi Linchi:
I don't get an error. It appears to work successfully. But when I look
at the user's roles again, it's still there.
On Feb 12, 12:03=A0pm, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> What error message did you get when you tried to remove it from the role?
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
> > I have a user in a database role that I cannot remove from the role.
> > If I go into the user's properties and deselect the role, click OK,
> > then go back in, the role is still checked.
> > I've tried to remove them via sp_droprolemember without success.
> > I am able to add and drop the user from other roles, though, and I'm
> > able to add/drop other users to the same role.
> > How do I drop them from the role?
> > Using: SQL Server 2005 Enterprise- Hide quoted text -
> - Show quoted text -|||How did you verify whether it's still there in the role? If you are using a
GUI tool, could this be a case of the GUI interface not being refreshed? I
know this may be too obvious, but...
Linchi
"cbtechlists@.gmail.com" wrote:
> Hi Linchi:
> I don't get an error. It appears to work successfully. But when I look
> at the user's roles again, it's still there.
>
> On Feb 12, 12:03 pm, Linchi Shea
> <LinchiS...@.discussions.microsoft.com> wrote:
> > What error message did you get when you tried to remove it from the role?
> >
> > Linchi
> >
> >
> >
> > "cbtechli...@.gmail.com" wrote:
> > > I have a user in a database role that I cannot remove from the role.
> > > If I go into the user's properties and deselect the role, click OK,
> > > then go back in, the role is still checked.
> >
> > > I've tried to remove them via sp_droprolemember without success.
> >
> > > I am able to add and drop the user from other roles, though, and I'm
> > > able to add/drop other users to the same role.
> >
> > > How do I drop them from the role?
> >
> > > Using: SQL Server 2005 Enterprise- Hide quoted text -
> >
> > - Show quoted text -
>|||If I use sp_helpuser 'theuser' I don't see the role listed.
If I open the properties of the user, the role is listed. I've
refreshed with the same results.
Weird
On Feb 12, 2:26=A0pm, Linchi Shea <LinchiS...@.discussions.microsoft.com>
wrote:
> How did you verify whether it's still there in the role? If you are using =a
> GUI tool, could this be a case of the GUI interface not being refreshed? I=
> know this may be too obvious, but...
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
> > Hi Linchi:
> > I don't get an error. It appears to work successfully. But when I look
> > at the user's roles again, it's still there.
> > On Feb 12, 12:03 pm, Linchi Shea
> > <LinchiS...@.discussions.microsoft.com> wrote:
> > > What error message did you get when you tried to remove it from the ro=le?
> > > Linchi
> > > "cbtechli...@.gmail.com" wrote:
> > > > I have a user in a database role that I cannot remove from the role.=
> > > > If I go into the user's properties and deselect the role, click OK,
> > > > then go back in, the role is still checked.
> > > > I've tried to remove them via sp_droprolemember without success.
> > > > I am able to add and drop the user from other roles, though, and I'm=
> > > > able to add/drop other users to the same role.
> > > > How do I drop them from the role?
> > > > Using: SQL Server 2005 Enterprise- Hide quoted text -
> > > - Show quoted text -- Hide quoted text -
> - Show quoted text -