IBM Security i2

Expand all | Collapse all

how to allow Guests to upload xlsx files to ibase

  • 1.  how to allow Guests to upload xlsx files to ibase

    Posted Thu November 12, 2020 09:39 AM
    Edited by makcim s. Thu November 12, 2020 09:40 AM
    Hello,

    I'm trying to allow a group of users (Guests) uploading xlsx files. Is there a way to do that without giving them a system role as database creator? So far I've read the documentation (couldn't find anything there) and tried some particular options; the only one it seems to do the trick is setting the group as database creator (which includes a lot more power than what I expected to give them).


    I'm using iBase 8.9.

    Regards
    Makcim

    ------------------------------
    makcim s.
    ------------------------------


  • 2.  RE: how to allow Guests to upload xlsx files to ibase

    Posted Fri November 13, 2020 10:26 AM
    Hi Makcim,

    To restrict functionality to iBase features, you need to use 'System Commands Access Control' from the Security menu in iBase Designer. This will allow you to deny specific iBase functionality to user groups.

    For more information, check the iBase documentation for System Commands Access Control here: https://www.ibm.com/support/knowledgecenter/en/SSXW43_9.0.0/com.ibm.i2.ibase.designer.doc/setting_up_system_commands_access_control_groups.html?cp=SSXVXZ_2.3.3


    ------------------------------
    Sam Chapman
    ------------------------------



  • 3.  RE: how to allow Guests to upload xlsx files to ibase

    Posted Fri November 13, 2020 09:56 AM

    Hello Makcim.  
     
    you are correct. System roles are far to powerful.  They are not needed for what you wish to do. 
     
    To allow users to upload/import into iBase you need to allow the Guest users/group these permissions:   
     

    • they need access to Folder objects (where the import specifications are created/saved) 
    • add/update/delete records, (otherwise they would be able to see or create import specifications but not run them to add data) 
    • whether you wish users to make use of other users import specifications/folders, is also an option. 
    iBase designer modification of Guest group to allow importing of spreadhseet data

    Any user added to that group will have the following permissions:- 

    Guest group settings

    I hope this information helps.

    ------------------------------
    KEVIN GILLIS - IBM Software Support
    ------------------------------



  • 4.  RE: how to allow Guests to upload xlsx files to ibase

    Posted Fri November 13, 2020 10:20 AM
    Hello,

    Thanks for your reply. I tried several combinations many times, and from what I gathered there's no standard behaviour coming from iBase (8.9). Sometimes the same set of permissions lets me upload an xls, and others don't. Could it be a bug? 

    Again, thanks for your time.

    ------------------------------
    makcim s.
    ------------------------------



  • 5.  RE: how to allow Guests to upload xlsx files to ibase

    Posted Mon November 16, 2020 05:59 AM
    Hello,
    We are not aware of any bugs in this area.
    Once you apply a set of conditions to a group, then all members of that group should share the same capabilities.
    You must ensure all users are on the same version of iBase and are on the same version of the 3rd party software, such as Office/Excel etc.
    IF there are differences per user within a group, such as the use/capability of using iBase importing to import xlsx data then that would suggest a difference in the end user's environment/infrastructure. e.g. versions of excel, settings within excel or the directory structure holding the source files etc.
    One way to test for that would be to have users utilise/log onto each others laptop/PC and see if the problem follows the user or stays with the laptop/PC. Not so easy to do with Covid restrictions I appreciate.
    IF you still have problems then you should raise a case with the IBM Support team https://www.ibm.com/mysupport/s/?language=en_US and the Support team can investigate further. 

    Regards,
    Kevin


    ------------------------------
    KEVIN GILLIS
    ------------------------------