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) / Manufacturing Security...
Microsoft Dynamics GP (Archived)

Manufacturing Security Roles and Tasks

(0) ShareShare
ReportReport
Posted on by Angel Nuñez

We are getting ready to implement Advance Manufacturing and I've been tasked to create the security roles and tasks for this module. Can anyone share some common manufacturing security roles. GP only has MFG ADMIN and MFG INQUIRY.

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Manufacturing Security Roles and Tasks

    You are most welcome Angel

    Please feel free to share any further inquiries

  • Angel Nuñez Profile Picture
    Angel Nuñez on at
    RE: Manufacturing Security Roles and Tasks

    Thanks Mahmoud. The provided script yielded not results. So I'm going to run the Clear Data routine as recommended by Leslie Vail in this post: https://community.dynamics.com/gp/f/32/p/31473/54576.aspx#54576.

    Now I have a good starting point.

    Thanks again.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Manufacturing Security Roles and Tasks

    Hello Angel

    It is a good idea to start with clean and customized roles which are tailored to your business needs. Initially, you could consider David Musgrave legacy script,

    "

    USE DYNAMICS
SELECT  R.PRODNAME,
		ISNULL(O.SECURITYTASKID, '') AS SECURITYTASKID ,
        ISNULL(T.SECURITYTASKNAME, '') AS SECURITYTASKNAME , --ISNULL(T.SECURITYTASKDESC,'') AS SECURITYTASKDESC,
        R.PRODNAME ,
        R.TYPESTR ,
        R.DSPLNAME ,
        R.RESTECHNAME ,
        R.DICTID ,
        R.SECRESTYPE ,
        R.SECURITYID
FROM    DYNAMICS.dbo.SY09400 R
        FULL JOIN DYNAMICS.dbo.SY10700 O ON R.DICTID = O.DICTID
                                            AND O.SECRESTYPE = R.SECRESTYPE
                                            AND O.SECURITYID = R.SECURITYID
        FULL JOIN DYNAMICS.dbo.SY09000 T ON T.SECURITYTASKID = O.SECURITYTASKID
		WHERE PRODNAME = 'Manufacturing'

    "

    The script above will retrieve more than a thousand record including several out of the box security tasks with detailed explanation for each one of them specifically for the manufacturing module. As well as the resources which are not used in any out of the box security task. Here are the out of the box security tasks to consider:

    ADMIN_MFG_006*            Manufacturing Company Tables                       
    ADMIN_MFG_007*            Manufacturing System Tables                       
    ADMIN_MFG_ROUTINES*      Manufacturing Routines                             
    ADMIN_MFG_SYS*            Set Up Manufacturing System                       
    ADMIN_MFG_USER*          Set Up Manufacturing User                         
    ADMIN_MFG_UTILS*          Manufacturing Utilities                           
    CARD_MFG_BOM*            Enter/Edit Manufacturing BOM Information           
    CARD_MFG_DRAW*            Enter/Edit Manufacturing Drawing Information       
    CARD_MFG_IV*              Enter/Edit Manufacturing Inventory Information     
    CARD_MFG_JC*              Enter/Edit Manufacturing Job Costing Information   
    CARD_MFG_MPS*            Enter/Edit Master Production Scheduling Information
    CARD_MFG_MRP*            Enter/Edit MRP Information                         
    CARD_MFG_QA*              Enter/Edit Manufacturing QA Information           
    CARD_MFG_ROUTING*        Enter/Edit Manufacturing Routings Information     
    CARD_MFG_SC*              Enter/Edit Manufacturing SC Information           
    CARD_MFG_SOP*            Enter/Edit Manufacturing SOP Information           
    CARD_MFG_WC*              Enter/Edit Manufacturing Work Centers Information 
    INQ_MFG_BOM*              View Manufacturing BOM Information                 
    INQ_MFG_CRP*              View Manufacturing CRP Information                 
    INQ_MFG_DRAW*            View Manufacturing Drawing Information             
    INQ_MFG_ECM*              View Manufacturing ECM Information                 
    INQ_MFG_JC*              View Manufacturing Job Costing Information         
    INQ_MFG_MO*              View Manufacturing MO Information                 
    INQ_MFG_MRP*              View Manufacturing MRP Information                 
    INQ_MFG_ROUTING*          View Manufacturing Routings Information           
    INQ_MFG_WIP*              View Manufacturing Work In Process Information     
    MFGDEFAULTUSER*          Manufacturing general user                         
    RPT_MFG_BOM*              MFG BOM Reports                                   
    RPT_MFG_CRP*              MFG CRP Reports                                   
    RPT_MFG_DC*              MFG Data Collection Reports                       
    RPT_MFG_DRAW*            MFG Draw Reports                                   
    RPT_MFG_ECM*              MFG ECM Reports                                   
    RPT_MFG_IV*              MFG Inventory Reports                             
    RPT_MFG_JC*              MFG Job Costing Reports                           
    RPT_MFG_MACH*            MFG Machine Reports                               
    RPT_MFG_MO*              MFG Manufacture Order Reports                     
    RPT_MFG_MPS*              MFG MPS Reports                                   
    RPT_MFG_MRP*              MFG MRP Reports                                   
    RPT_MFG_OC*              MFG Option Category Maintenance Reports           
    RPT_MFG_QA*              MFG QA Reports                                     
    RPT_MFG_RTG1*            MFG Planning Routings Reports                     
    RPT_MFG_RTG2*            MFG Working Routings Reports                       
    RPT_MFG_SF*              MFG Sales Forecasting Reports                     
    RPT_MFG_WC*              MFG Work Centers Reports                           
    TRX_MFG_ECM*              Enter/Edit Manufacturing ECM Transactions         
    TRX_MFG_JC*              Enter/Edit Manufacturing Job Costing Transactions 
    TRX_MFG_MO*              Manufacturing MO Transactions                     
    TRX_MFG_MRP*              Enter/Edit MRP Transactions                       
    TRX_MFG_QA*              Enter/Edit Manufacturing QA Transactions           
    TRX_MFG_ROUTING*          Enter/Edit Manufacturing Routings Transactions     
    TRX_MFG_SC*              Enter/Edit Manufacturing SC Transactions           
    TRX_MFG_SF*              Enter/Edit Manufacturing SF Transactions           
    TRX_MFG_SOP*              Enter Manufacturing SOP Transactions               
    TRX_MFG_WIP*              Enter/Edit Manufacturing WIP Transactions         

    The above can be a good starting point for creating a customized security roles.

    Your feedback is highly appreciated,

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,886 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,766 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans