Post reply

SQL instance logins

  • March 16, 2009 at 7:32 am

    #132254

    Hi all,

    I have a login group account in which 5 people are members of. The account has sysadmin fixed server role. However, I would like to remove only one member from the group account and leave all others intact. Is there a way to remove exactly that member from the group?

    Thanks for your hint

    Niyala

  • March 17, 2009 at 12:09 am

    #960816

    I am taking a guess it is an Active Directory group... So in Active Directory remove that person from the group and they will not be able to access it then :).

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply