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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to Pull security t...
Microsoft Dynamics GP (Archived)

How to Pull security task details each series wise

(0) ShareShare
ReportReport
Posted on by Arunsh 606

Hi All,

Hope everyone good. Its been a long time coming to community asking questions.

I have a question related to security tasks in GP.

I need data of security tasks each series wise. Like

In Inventory series what are the security tasks associated with it.

Financial Series Security tasks.

I searched almost everywhere but couldn't find query or solution. If you guys can share on this it would be really helpful.

Regards,

*This post is locked for comments

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    There is a 'Security Task Setup Report' which will show you all security operations the security task gives access to, by Type, Security Operation, Series and Dictionary.

    There is also a 'Security operation Access Report' which will show you which users are assigned/have access to a specific security operation.

    Both of these reports can be accessed and ran from the Security Task Setup window. (Administration > Setup > System > Security Tasks).

    In your case, you could choose a security task under Financial, such as 'ADMIN_FIN_001*', then run the Security Task Setup Report, which will show which operations this task gives access to.

    Unfortunately, with this report, there isn't a way to select multiple security tasks or all security tasks under a specific series, like Financial or Inventory.

    The SY10700 table doesn't differentiate by series, only DICTID, so there's not any way to use a SQL view or script to get a better form of this type of report either.

    Let me know if you have any questions on the above.

    Thanks

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    This view from Victoria Yudin's web site will provide the information I think you need.

    Kind regards,

    Leslie

    CREATE VIEW view_Security_Roles_and_Tasks

    AS

    /**

    view_Security_Roles_and_Tasks

    Created Mar 12 2009 by Victoria Yudin - Flexible Solutions, Inc.

    For updates see victoriayudin.com/gp-reports

    Shows all security roles and tasks by user by company

    **/

    SELECT S.USERID UserID, S.CMPANYID CompanyID,

    C.CMPNYNAM CompanyName, S.SecurityRoleID,

    coalesce(T.SECURITYTASKID,'') SecurityTaskID,

    coalesce(TM.SECURITYTASKNAME,'') SecurityTaskName,

    coalesce(TM.SECURITYTASKDESC,'') SecurityTaskDescription

    FROM SY10500 S   -- security assignment user role

    LEFT OUTER JOIN

    SY01500 C   -- company master

    ON S.CMPANYID = C.CMPANYID

    LEFT OUTER JOIN

    SY10600 T  -- tasks in roles

    ON S.SECURITYROLEID = T.SECURITYROLEID

    LEFT OUTER JOIN

    SY09000 TM  -- tasks master

    ON T.SECURITYTASKID = TM.SECURITYTASKID

    /** the following will grant permissions to this view to DYNGRP,

    leave this section off if you do not want to grant permissions **/

    GO

    GRANT SELECT ON view_Security_Roles_and_Tasks TO DYNGRP

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    I think this is about as close as we'd be able to get as it returns the list of security roles, security tasks, task names and security task description for each user and each company database. The only thing missing is that none of the tables have a 'Series' column so we can't divide it by series, such as Financial, Inventory, Purchasing, etc.

    Thanks Leslie.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    The Series assigned to the operations are in SY09400 TABLE

    Kind regards,

    Leslie

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    My bad, I skipped right past those columns. Thanks again.

  • Arunsh Profile Picture
    Arunsh 606 on at

    Thanks Leslie, I came across this query in victoriya Yudin but i missed SY09400  table with series. Thank you for the help.

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

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