script needed

  • Report of all users who have access to the database including their roles and privileges assigned - including administrators, and any access to alter data directly in the DB

    List of users with to NT Authority\SYSTEM , BUILTIN\Administrators , and BUILTIN\SQL Server on a particular database

  • Take a look in the script repository http://www.sqlservercentral.com/Scripts/. You can find many scripts to get information about permissions. One of them will most certanly fit your needs.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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