Permission/Security setup via the OneDesktop IDE (RDM)

  • 15 September 2023
  • 4 replies
  • 52 views
J
Userlevel 2
Badge +1

Setting permissions for groups via the IDE.

  • Ensure your groups exists in KeyCloak first
  • In the IDE go to your RDM Project and complete the following under "Security"
    • Right click on Roles
    • Select New role

 

 

  • Add the name and description of the role (be sure to use the same names that you setup in KeyCloak) then click Apply and OK
  • Expand the new role, and right click on Entities then select Edit…

 

 

  • Add the Tables and the Table level permissions in the next window

 

 

  • NOTE: Table permissions do not give column level permissions.
  • Double click the number next to the table that you wish to setup permissions for
  • Notice that there are options for "View for All Columns" and "Modify for All Columns." However, if you want to select only certain columns, you can do that below with the following steps.
    • Add the column names you want permissions to be given for, and select View and/or Modify for the given column

 

 

  • When complete, click Apply then OK
  • To ensure these permissions are applied to the Web Admin double click on Security, and check the boxes for "Row permission editable" and "Fixed permissions."
    • Note that once applied, you will not be able to edit permissions in the IDE.

 

 

4 replies

Cansu
Rank
Userlevel 6
Badge +7

Great quick tip thank you for sharing @Jason.Suptic !

Check out Our Community Recommended Journey to get started on the community 🙋‍♀️
O
Userlevel 2
Badge +5

Hello @Cansu and @Jason.Suptic ,

Could you please point to any document for ‘Row Level Security’ in RDM? 

 

I have tried applying something, but it is not working.

  1. Create new role for this table.
  1. for modification given these 2 conditions. User with the given new role should be able to edit only these 2 records. He can view other records but only able to edit these two.

 

It is even showng in we page too . 

 

 

I also get such warning messages while I upload new configuration on RDM with filter conditions.

If you have tried this option or any other way of restricting Edit functionality in a table for selected rows, please let me know. Really Appreciate.

Kind regards,

Ojaswini

A
Rank
Badge

Hi @Ojaswini,

There are docs available for setting row level permissions in RDM which can be downloaded at the support portal here: https://support.ataccama.com/downloads/15.1.0

You will find the relevent information under section 11.3.2 of the RDM Web Application User Guide.

Could you try enabling the option ‘row permission editable’ in the security tab? This is mentioned in the original post by @Jason.Suptic but doesn’t look enabled from the screenshot you have shared.

Thanks,

Antonio

maykwok_hamilton
Userlevel 3
Badge +2

Won’t “BusinessSegmentID = 998 and BusinessSegmentID = 999” be an impossible scenario so nothing will ever satisfy it?

 

Your value in the field can never be both 998 and 999, so the user would be able to edit neither records.

 

Can you try with the “or” condition, or “BusinesSegmentID in (998, 999)” ?

 

On your second point when uploading configuration - if you have changed security settings on the webapp, then every time you upload configuration with different security settings it will give this warning and ignore your config from model project.

 

Depending on your version, if you have this button, it will instruct the application to use config from model project:

 

Reply


Community Terms of Use & ConditionsCookie settings