Re: How can I obtain a report of users and roles in SQL Server?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 10/19/05

  • Next message: Russell Fields: "Re: How can I obtain a report of users and roles in SQL Server?" 
    Date: Wed, 19 Oct 2005 13:03:51 +0530

    See:-

    SYSPROTECT system table and system procedure SP_HELPROTECT

    Thanks
    Hari
    SQL Server MVP

    "José Archondo" <jarchondo@spvs.gov.bo> wrote in message
    news:uMv%23UlC1FHA.664@tk2msftngp13.phx.gbl...
    >I need a query (script) or a tool to obtain a report (or audit report) for
    > all databases instanced into SQL Server, just for an entittlement review
    > aun
    > audit reports.
    >
    > The fields are:
    >
    > User, role, permissions, last date access
    >
    > Best regards to everyone.
    >
    > José
    >
    >

  • Next message: Russell Fields: "Re: How can I obtain a report of users and roles in SQL Server?"