Automate

 View Only

  • 1.  Query Authorization Error

    Posted 06-17-2022 10:28
    In order for a user to run a query that I wrote, do they have to have security access to view the underlying tables?  
    Thank you!

    ------------------------------
    Lynne Riggan | Business Systems Support
    Energy Transfer |lynne.riggan@energytransfer.com
    ------------------------------


  • 2.  RE: Query Authorization Error

    Posted 06-20-2022 07:32
    A runner can query data from any SAP table even without having access to T-codes. That is how I interpret it because I have years of expertise writing and running Winshuttle queries. As an example, a user who only has access to the material master roles is be able to query vendor and customer data.

    ------------------------------
    Benjamin Kielas | Data Materials
    Generac Power Systems, Inc. | (262) 510-6580
    ------------------------------

    Original Message


  • 3.  RE: Query Authorization Error

    Employee
    Posted 06-20-2022 09:39

    Yes, Riggan, they need access to the tables - not necessarily the tcodes, as Benjamin pointed out.  Please also see the documentation on authorizations, and ways to control what they can see, optionally using authorization objects. https://docs.winshuttle.com/studio-en-20-2-online-help-studio-with-connect/authorizations-required-sap.htm\

    Best Regards,
    Sigrid



    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message