Home Forums SQL Server 2008 SQL Server 2008 - General Request for script list of logins and the users? RE: Request for script list of logins and the users?

  • November 26, 2013 at 5:50 am

    #1669102

    ananda.murugesan (11/26/2013)

    Hi,

    I want script for getting command existing user, login and their permmission etc..

    there any built-in stored proc that can list the logins and the users with their permission level?

    thanks

    ananda

    You can use the sp_helplogins procedure. It takes an optional parameter for a login to match against.

    http://technet.microsoft.com/en-us/library/ms190304%28v=sql.100%29.aspx

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions