During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate Monitor.
This is part of a series of posts on Redgate Monitor. Click to see the other posts.
Permission Changes
Redgate Monitor Enterprise adds a few security features to the tool that track things that organizations can struggle to track as their estates grow. There is a security menu item at the top of your Redgate Monitor web page. You can see this expanded on our demo system at monitor.red-gate.com.
Click the permission entry and you will see this starts on a page that is titled Permissions. There are a few tabs below the title (Permission changes, Servers, Databases, Users). We start on Permission changes, which helps us to see the various changes that have occurred.
Below this, we see a date box that is set for the last week, along with a few other items. By default we show you the last week’s worth of changes and all the data. However, you can easily alter this.
This can be a lot of data, especially in an enterprise, so perhaps I only want to see certain things. I can click “Columns and choose which data I care about. Here, I’ll uncheck a few boxes.
Notice this has rolled up some changes, so I don’t see quite as much as data as I do in the default view. This is useful when I want to see the “who had a change” and not every detail.
I can, of course, change the date range. We give you some quick defaults, or you can use the calendar picker to choose a range.
When I do this, I only see some changes, those that apply to that date range.
If I want to further filter things, I can choose that item. You can see the various items below I can choose from.
Let’s set this to “Changed by” the sa account. When I do that, notice the “Filters” icon is annotated saying I have 1 filter condition. I also only see the one row changed by SA.
I will expand my date range and remove the filter while adding all the columns, and I see this data:
That’s a lot, but I can change the density. Here are the choices.
Here is compact. Now all 10 rows fit on the page:
Comfortable only shows 7 rows (9 in standard).
Lastly, I can set the number of rows on the page in the lower right.
Summary
Security is becoming something more people need to report on, especially public companies or those regulated. This feature of Redgate Monitor helps you satisfy auditor requests with the information they need to verify you are watching your systems.
Or, at least that you know Redgate Monitor is doing so.
Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.
