hassave.blogg.se

Ibm i access client solutions run sql script
Ibm i access client solutions run sql script










ibm i access client solutions run sql script

To restrict access to the Integrated File System tasks within ACS, you need to restrict access to all file systems within Navigator Application Administration, as the following screen capture shows. In addition, I wrote an article summarizing function usage IDs some time ago. FYI, if you are not sure what the text string means (e.g., QIBM_XD1_OPNAV_PRINTOUT), you can use the WRKFCNUSG command which will display the text string along with a brief function description. In the remaining examples, I’m not going to show the error messages they all are similar and state the function usage that has been restricted. When a user is not allowed to use the Printer Output functions, taking Printer Output from the main ACS menu results in the following error: Printer Output can be restricted from access by customizing Printer Output in the Basic Operations section of Navigator for i functions. In all of my examples, I have customized the Application Administration settings to exclude user DAWNMAY from specific functions.

ibm i access client solutions run sql script

ACS caches the fact that a user is authorized to a function if a user had been using ACS and becomes restricted from a function, ACS must be restarted for the restriction to take effect.īelow I show the details of what must be set in Application Administration in order for the user to be restricted from the corresponding function in ACS.

#Ibm i access client solutions run sql script update

The support added in the January 2017 update allows you to restrict each of the above functions in its entirety by disabling the entire category using App Admin.Īs you are getting started with this support, you may stumble upon a situation where it appears as if the customizations do not take effect.

  • Database tasks (Run SQL Scripts and SQL Performance Center)įunctions that are controlled by Application Administration for Client Applications are:.
  • If you had restricted access to Navigator tasks by using Application Administration, or if you used the Client Applications to restrict features of IBM i Access for Windows, those application administration restrictions now apply to ACS.įunctions that are controlled by Application Administration for Navigator functions are:

    ibm i access client solutions run sql script

    If you aren’t aware of this capability and want to know more, refer to the Getting Started document, Section 9.5 Customized Packages.īut did you know that with the latest ACS update (January 2017), you could also use Application Administration to restrict the tasks that a user can access with Access Client Solutions? Restricting access in this way removes the function from the main GUI and disables its usage from the command line. I suspect most readers already knew about application administration with Navigator.Īccess Client Solutions (ACS) has had the ability to restrict the usage of specific functions by modifying the AcsConfig.properties file. Last week I wrote about Application Administration with Navigator for i.












    Ibm i access client solutions run sql script