What’s included in those SQL rpt roles?

Today’s #TipTuesday is a security tip to help you identify what exact permissions the SQL fixed database roles have, that start with rpt*. If you’re granting access to some of your windows users or groups, you want to know what they can get into, right?

The purpose behind the rpt* roles is generally for SSRS (SQL Reporting Services) reports that ship with Dynamics GP since users running those reports are outside of GP, not tying into GP permissions. There are plenty of other posts out there about GP & SSRS, so I am not going to get into that here. Instead I am going to show you a SQL query I’ve used to see what permissions are granted to what role, login, user or group in SQL.

Continue reading “What’s included in those SQL rpt roles?”

Changing Password Managers

Back in October last year, I posted a couple of articles around my recommendations and use of Two-Factor authentication. (Here’s part 1 and part 2 for those articles, if you’re interested in reading them.)

In my part 2 post, I indicated that I was also using a password manager and was using LastPass at the time. I have recently switched to 1Password and after posting a couple of things about that on Twitter, a few friends and followers expressed interest in knowing more about why I switched and how I would compare the two of them.

Continue reading “Changing Password Managers”

Two Factor Authentication, part 2

Today’s #TipTuesday is a continuation of last week’s first post on Two Factor Authentication, 2FA for short. Today I am not getting into examples, as I found an interesting article last week after posting my first blog, that illustrates some of why 2FA and password managers are important. Instead of trying to document what already exists, I focused on some other things in this post and end this with where to get setup information for some common sites.

Continue reading “Two Factor Authentication, part 2”

Two Factor Authentication, part 1

Today’s #TipTuesday is a topic that likely needs multiple posts to handle it properly. In fact, as I write this, it’s already long before I even get into examples and “how to” on common sites so this will be a mini-series in my #TipTuesday series (a series within a series?!). Long story short: with all of the data breaches and hacks out there, the best thing you can do to protect your logins is to turn on Two Factor Authentication (2FA). There are multiple names for this and multiple acronyms most of which generally have the same or similar meanings. (The other most common term you might hear is MFA (multi-factor authentication).)

Continue reading “Two Factor Authentication, part 1”

GP Utilities user permissions part 2

Today’s #TipTuesday is short, but also related to a post from a couple of weeks ago where I posted what the minimum permissions required were for using GP Utilities. Coincidentally (or perhaps not?), last week a consultant posted a “tip” on this on the GPUG Open Forum, where there was a dangerous suggestion made, that I’m not sure they fully realized the implication of (at least I hope they didn’t think that one through and posted in haste…).

Continue reading “GP Utilities user permissions part 2”

Unassigned Security Report & Superuser roles

This wasn’t going to be a “Tip” post but it’s Monday night as I write this, so it’s now becoming this week’s #TipTuesday. Funny how deadlines work! 🙂

Late last week, I was working on some upgrade tasks as my firm is going through an upgrade from Dynamics GP 2013 to GP 2016. One of the tasks on my checklist was to review the Unassigned Security Report for new features and update security roles as needed. However, I ran into an issue.

Continue reading “Unassigned Security Report & Superuser roles”

Microsoft Connect – Obscure Smartlist Reminder Issue

Tonight I decided to clean up my “future blog posts” folder, where I dump in screen shots and brief snippets of text for future posts, hoping I remember what I was thinking at the time the entire topic would look like!  This one is a snippet and a URL that I’m lacking screen shots on so I’ll do my best to describe it.
Continue reading “Microsoft Connect – Obscure Smartlist Reminder Issue”

Report Writer demystified – part 2 – other considerations

My last post was the introduction to dictionaries and launch files for those new to Report Writer (or GP).  This post is all about things to keep in mind before you actually venture into Report Writer to start working.  It’s rather boring stuff but it’s important to protect your reports from becoming corrupt or damaged due to poor process or lack of understanding.

Continue reading “Report Writer demystified – part 2 – other considerations”

Scroll to top