IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  Lost "Row Access control" in table definition

    Posted Wed October 02, 2024 12:27 PM

    Hello:   

    In ACS, I can't see "Row Access control", which I saw in table definition of the old System i Navigator

    In ACS:

    In the old System i Nav:

    Note: "Control de acceso a filas" means "Row access control" in Spanish, and is the option that I can't see now.

    Any idea what could happen?



    ------------------------------
    Carlos Balestrazzi
    ------------------------------

    #IBMiAccessClientSolutions


  • 2.  RE: Lost "Row Access control" in table definition

    Posted Wed October 02, 2024 03:22 PM

    Carlos - maybe the version you have is outdated ? Here is a screen shot from my ACS that shows what you are looking for



    This is the version I'm on - which admittedly, I'm a little behind on myself





    ------------------------------
    Rich Malloy
    ------------------------------

    Original Message


  • 3.  RE: Lost "Row Access control" in table definition

    Posted Wed October 02, 2024 03:53 PM
    Thanks Rich and Rohit:

    I have the latest version of ACS
    image.png



    I suspect that the "Restrict on drop" option available in V7R5 overridden the view of the "Row access control" option...











    Original Message


  • 4.  RE: Lost "Row Access control" in table definition

    Posted Wed October 02, 2024 04:29 PM

    I see in the ACS updates that they added that option, but I see nothing that says they purposely removed the other option. Those 2 functions / options are very different so not sure why they would remove the "Row Access" option simply to make room for the 'Restrict on Drop' Option. I don't have a 7.5 system to test any theories out but I wonder if there is some security check that might be happening now that perhaps wasn't being enforced with < 7.5 systems. Thinking along the lines of the functional usage areas where perhaps *ALLOBJ isn't sufficient to view/change a setting etc. The ones that come to mind the most are QIBM_DB_SECADM and QIBM_DB_SQLADM . 



    ------------------------------
    Rich Malloy
    ------------------------------

    Original Message


  • 5.  RE: Lost "Row Access control" in table definition

    Posted Wed October 02, 2024 03:46 PM

    Dear @Carlos Balestrazzi and @Rich Malloy, 

    I just checked on my side and here is the screenshot which is still showing "Row Access Control" in IBM i ACS. I also tried to check it in release notes and i don't see it as discontinued. May be you should try to update to latest version as i am using same which is 1.1.9.6.



    ------------------------------
    Rohit Chauhan
    Senior Technical Specialist
    Norway
    ------------------------------

    Original Message


  • 6.  RE: Lost "Row Access control" in table definition

    Posted Wed October 02, 2024 10:51 PM
    Edited by Satid S Wed October 02, 2024 11:02 PM

    Dear Carlos

    I have checked in ACS GUI and found that the option Row Access Control runs this  ALTER TABLE QIWS.QCUSTCDT ACTIVATE ROW ACCESS CONTROL (check the option and click Show SQL to see this). 

    Assuming your IBM i server at issue is at release 7.2 or later, I have a guess.  Since a table must first be activated for row access control to be defined (and can also be deactivated), it may be possible that your table EMAILDIRE was already activated for row access control and ACS may be designed to be able to detect this (and remove the option from the GUI) while the old System i Nav is not.    I think you can check on this by running DSPFD against EMAILDIRE or display its Descriptions from ACS GUI to see if you see such an activation. 


    ------------------------------
    Satid S
    ------------------------------

    Original Message


Related Content