OMG! Simple Exportable Security Access Report?

(1) Share

Report

Posted on by ArtCampbell

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

All responses (2)

Answers (0)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: OMG! Simple Exportable Security Access Report?

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

Community Member on at

Like (1)

Report

RE: OMG! Simple Exportable Security Access Report?

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