Exam 70-458 – Objective 2 – Implement Security

This entry is part 2 of 8 in the series Exam 70-458

This entry is part 2 of 8 in the series Exam 70-458  Manage logins and server roles Configure server security (http://msdn.microsoft.com/en-us/library/bb283235.aspx) Secure the SQL Server using Windows Account/SQL Server accounts, server roles Server-Level Roles (http://msdn.microsoft.com/en-us/library/ms188659.aspx) Create log in accounts (http://msdn.microsoft.com/en-us/library/aa337562.aspx) Manage access to the server, SQL Server instance, and databases Database Roles (http://msdn.microsoft.com/en-us/library/ms189121.aspx) Create and […]

Read More »

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.

Read More »

List Members in Each Database Role

We receiving have been working with auditors to provide list of SQL logins that exist in each database role defined. Here is a short script to return all the members of each group that can easily be copied into Excel and shared with auditors and anybody else looking for this information. It basically cursors through […]

Read More »