Post reply

Is there a SP for listing all user logins?

  • September 26, 2005 at 9:26 am

    #168524

    Is there a stored procedure that lists all the login accounts on a server?

    If I use windows authenitization, and the windows user was deleted does that automatically delete the login and permissions from the server?

  • September 26, 2005 at 9:44 am

    #593048

    select name

    from master.dbo.Syslogins

    this shows the login names, but if you administer authentication thru windows groups, you cannot look at the members of the domain groups thru this query.

  • September 26, 2005 at 9:50 am

    #593052

    I am using Windows Authentication Mode and this query does show the list of users.

    And i guess deleting a Windows login does not delete his permissions on SQL server because i deleted one person that way and they show up in the list of logins.

  • September 26, 2005 at 10:30 am

    #593066

    With windows logins, you should be able to see individual users added to the list.

    domainname\username.

    But if you have Domain groups. you cannot see individual members.

    yes, deleting/denying access to domain, does not effect usernames shown in sql server.

    They cannot gain access to the server though, they must authenticate to the domain first.

     

  • September 26, 2005 at 10:42 am

    #593072

    Thanks for the info!

Viewing 5 posts - 1 through 4 (of 4 total)

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