D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  Convert AX 2009 to Read Only access

    Posted Apr 20, 2022 04:45 PM
    Edited by Jeff Maynard Apr 20, 2022 04:45 PM
    We are about to go live on D365 F&O and want to put our AX 2009 environment in a "read only" state so that folks can still access it for historical look-ups but not change any data...is there a way to accomplish that without traversing the permissions tree for each role and changing all active nodes in the tree to "View" (we don't want to change any of the things users can ACCESS in their AX roles, but we do want to make everything they access read only).

    Thanks in advance for your input!


    Jeff Maynard
    VP of Administration
    Cope Plastics, Inc.
    Alton IL
    ------------------------------


  • 2.  RE: Convert AX 2009 to Read Only access

    MICROSOFT MVP
    Posted Apr 21, 2022 11:04 AM
    Jeff,

    If you want to keep the role access the same except change everything to Read access, then the only answer is to do that process manually. I can not think of a way to automate the process unless you wanted to write custom code to do so.

    ------------------------------
    Alex Meyer
    Director of Microsoft Software Development
    Fastpath
    Des Moines, IA
    ------------------------------



  • 3.  RE: Convert AX 2009 to Read Only access

    Posted Apr 22, 2022 08:46 AM
    Could you change the read only access on the SQL database? Or would that not work. We will want to do the same when we go live with 365.

    ------------------------------
    Lana McCollough
    IT Applications Manager
    Bay Industries Inc.
    Green Bay WI
    ------------------------------



  • 4.  RE: Convert AX 2009 to Read Only access

    SILVER CONTRIBUTOR
    Posted Apr 22, 2022 06:01 PM
    We did a reimp of AX 2009 a few years back and wanted to keep the old database as read only for our users, without changing their access level.  The way we accomplished it, was by adding read only triggers on the tables in SQL.

    ------------------------------
    Beth Brooks
    IS Manager
    Camco Manufacturing, Inc
    Greensboro NC
    ------------------------------



  • 5.  RE: Convert AX 2009 to Read Only access

    Posted Apr 22, 2022 06:09 PM
    Beth,

    We still want to run SSRS reports and utilize document management in this "read only" environment - did putting those table triggers in place affect any of those pieces?!?!?  We don't have a SQL DBA on staff so we're shooting a little in the dark on this one.

    Thanks,
    Jeff

    ------------------------------
    Jeff Maynard
    VP of Administration
    Cope Plastics, Inc.
    Alton IL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role