Skip to content

List What Permissions Each Database Role or User Has in a Database

Below is another script I frequently use to list what users or roles have what permissions to tables and views in our database. It basically cursors through the list of objects and stores the results of sp_helprotect in a temp table then displays the results.

Leave a Comment