Christina Phillips does a great job looking at SQL Report Security in her latest post at Dynamics GP Land.
Dynamics GP Land: And a One, And a Two, SQL Report Security
Reporting & BISQL & DataInstall, Upgrade & Admin
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.