web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / OMG! Simple Exportable...
Microsoft Dynamics GP (Archived)

OMG! Simple Exportable Security Access Report?

(1) ShareShare
ReportReport
Posted on by ArtCampbell 20

Mult part question here that starts easy>>Is there a simple report I can export to show Security/Access in GP? Could this get granular to include tables? Customizations? 

Help!!...again!

Thanks Everyone

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    1) Write a SSRS or build a smart list - Below query should start you up.

    SELECT     dbo.SY10500.USERID, dbo.SY01500.CMPNYNAM, dbo.SY09000.SECURITYTASKID, dbo.SY09000.SECURITYTASKNAME, dbo.SY09000.SECURITYTASKDESC,
                          dbo.SY09000.SECURITYTASKCATEGORY, dbo.SY09100.SECURITYROLEID, dbo.SY09100.SECURITYROLENAME, dbo.SY09100.SECURITYROLEDESC,
                          dbo.SY09100.SECROLETYPE
    FROM         dbo.SY10500 INNER JOIN
                          dbo.SY09100 ON dbo.SY10500.SECURITYROLEID = dbo.SY09100.SECURITYROLEID INNER JOIN
                          dbo.SY10550 ON dbo.SY10500.USERID = dbo.SY10550.USERID AND dbo.SY10500.CMPANYID = dbo.SY10550.CMPANYID INNER JOIN
                          dbo.SY10600 ON dbo.SY10500.SECURITYROLEID = dbo.SY10600.SECURITYROLEID INNER JOIN
                          dbo.SY10700 ON dbo.SY10600.SECURITYTASKID = dbo.SY10700.SECURITYTASKID INNER JOIN
                          dbo.SY09000 ON dbo.SY10600.SECURITYTASKID = dbo.SY09000.SECURITYTASKID INNER JOIN
                          dbo.SY01500 ON dbo.SY10550.CMPANYID = dbo.SY01500.CMPANYID

    2) There are canned security reports available in GP which can give you the info you are seeking.

    Cheers!

    Sanjay

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    Go to reports Menu>System>Security you can find many reports their. You can print with different criteria.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans