Assign role to another role

Options
Hi, 
we have two roles eni_facility_writers and eni_facility_reader. 
We would like to assign these two roles to at third role eni_facility. 
How we can do that from da? 
Thanks. 
Regards. 
Tagged:

Comments

  • Hi, 
    we have two roles eni_facility_writers and eni_facility_reader. 
    We would like to assign these two roles to at third role eni_facility. 
    How we can do that from da? 
    Thanks. 
    Regards. 
    If you have any suggestions about dql query to do that, please tell us. 
    Thanks. 
    Regards.
  • What exactly is the problem ? You should be able to do that via DA. When you add members to a group or role, you can select any existing user, group or role. If you want to do it via DQL:

    update dm_group object append groups_names = 'yourgroup' where group_name = 'eni_facility'

    From a functional perspective, your role eni_facility sounds more like a group than a role to me though.
  • In DA, select third role, and then click File->Add Members.  There is a picklist to filter to Show Roles.  Select the other two roles and move them to right.  Click OK.