• Hi MobashA.

    nice script, but not enough information.

    I've posted a script on a german website for sqlserver 2005, which you could use to show all users, grants and roles in a database.

    http://www.insidesql.org/beitraege/administration/berechtigungen-im-sqlserver-2005-anzeigen

    You will find it at the bottom.

    I had the idea after reading Jamie Thomson's blog:

    http://blogs.conchango.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions--_2800_2_2900_.aspx

    Have a nice day,

    Christoph

    Have a nice day,Christoph