Query the "user security" settings given to a folder by query builder

[rgonzalr]

Hello,

I'm using query builder to extract the objects saved in CMC, and I would like to know how can I obtain the user security give to a folder.

When I query (SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='Folder'), it returns the SI_ROLES_ON_OBJECT given to the folder, but it says nothing about the User Group.

When I query (SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND='CustomRole'), it returns the SI_OBJECTS_ASSIGNED_ROLE folders that have been granted that role, but it says nothing about the User Group.

And when I query (SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'UserGroup'), it returns the hierachy within the UserGroup is contained, but it says nothing about the Folders or Roles.

How can I relate all these three objects? Folder, UserGroup and CustomRole

Thanks in advance!

Rafael.

[DellSC · Accepted solution]

Unfortunately, you can't. QueryBuilder does not allow you to query for security information. So, you have two options:

1. Find a third-party product that will extract this information for you.

2. Write a program using either the .NET or the Java SDK to pull the information (I'm not sure whether the RESTful Web Service SDK has this functionality.)

-Dell

[rgonzalr · Accepted solution]

Thank you very much.

I've created a program with the example given on the "Business Intelligence Platform Java SDK Developer Guide" documentation:

https://help.sap.com/viewer/0225aa3e7b4b4b17b2d4a882e6f2de96/4.2.7/en-US/45a8a89b6e041014910aba7db0e...

Best regards!

[TJe]

You can get this information using the CMS DB universe Unlock the CMS database with new data access driver for BI 4.2. In the universe class InfoObjects/Security you can find the objects PrincipalName, PrincipalKind and Access.

regards
Thomas