Skip to main content
J
jesvam
August 21, 2024

Validate User DataCell Access in BR

  • August 21, 2024
  • 1 reply
  • 0 views

Hi, is there a way to completely validate data cell access for a user in a BR using the api? I'm looking for something that would run the same logic as you would expect from a cube view, basically validating cube, scenario, entity and sliced security at the same time. 

 I would expect a method that takes a user and a datacell object and returning true/false or similar.

 

1 reply

M
MarcusH
August 21, 2024

I don't think there is anything in the API to give you precisely that ie for this user check if they have access to this intersection. The closest I can think of is to use the method UserCubeSliceRights. That will return a data table that lists the data access slices and whether the user is in the group. You will have to work out how to process it as the data access slice might be adding or removing access.

Dim ForUser as String = "myuser"
Dim thisDataTableName as string = "SliceAccess"
Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
    Using ds As DataSet = BRApi.Database.ExecuteMethodCommand(dbConnApp, XFCommandMethodTypeId.UserCubeSliceRights, "{" & ForUser & "}{AllCubes}{}", thisDataTableName, Nothing)
        If Not ds Is Nothing Then
            If ds.Tables.Count > 0 Then
                Dim dt As DataTable = ds.Tables(thisDataTableName).Copy
                For Each dr As DataRow In dt.Rows()
                    Dim memberFilter As String = dr("MemberFilter")
                    Dim userInGroup As String = dr("UserInGroup")
                    Dim bhvInGroupInFilter As String = dr("BehaviorInGroupInFilter")
                    ' Now process it
                Next
            End If
        End If
    End Using
End Using

I have pieced it together from another script but I think it should work.

J
jesvamAuthor
August 21, 2024

Thanks Marcus! Yeah this combined with XFCommandMethodTypeId.GroupsForUsers and then just validate all group against cube, scenario and entities would work but seems very convoluted for something that could just be a api method. 

J
jesvamAuthor
August 21, 2024

Actually this wouldn't even work when I think about it unless exceptions for administrator groups etc are handled. What I did was just to loop through the entities and make a list of the entities in access group scope by validating them against the Brapi.Security.IsInGroup method

Terms & ConditionsAccessibility statement