Hi,
I am trying to read out the assignment of roles to groups from the repository database. Unfortunately, I can't find the right tables to join in my query. Does anybody know the right tables?
Thanks a lot.
Sylvana
Hello Sylvana!
Here a SQL Statement which we use to either get a list of users which are assigned to a specific role, or the other way round. The example would show a list of the roles which I have assigned:
select r.name as Rolle, auth.name as User_Namefrom dAlea olap --Repository inner join CCombModelRole r on olap.IDALEA = r.IDCOMBMODEL --Rolleninner join cCMRoleAuthObj cmroles --Verknüpfung über ModelRole ID on r.idcombmodelrole = cmroles.idcombmodelroleinner join cAuthObj auth on cmroles.idauthobj = auth.idauthobjwhere olap.name = 'name_of_your_repository'and auth.name like '%Gottesheim%'order by r.name asc;
Is it what you are looking for?
Best regards, Daniela
Thanks Daniela. This is exactly what I am looking for!
Hi Daniela
Do you perhaps know which table the permission names and descriptions and assignment to roles are stored in?
Kind regards
Paul
Paul, just a heads up that if you are using v.12, there are new functions that can be used for this task, so this is much easier and better alternative.. for v.11 - yes, tables and dev API, but this is more internal tools and queries
Hello Paul,
do you mean the permissions like import/export values, view, write values and so on? I guess that would be the table cPerm. But I don't know how to join it with the roles.
Thanks Nick.
We are still on v11, but I am looking forward to v12 and hopefully easier security administration.
Thanks Daniela.
I am still testing, but the following appear to work:
SELECT Roles.Name, Roles.Description, Perm.NameFROM dbo.dAlea AS OLAP INNER JOIN dbo.cCombModelRole AS Roles ON OLAP.IDAlea = Roles.IDCombModel INNER JOIN dbo.cCMRolePerm AS RolePerm ON Roles.IDCombModelRole = RolePerm.IDCombModelRole INNER JOIN dbo.cPerm AS Perm ON RolePerm.IDPerm = Perm.IDPermWHERE OLAP.Name = 'RepostoryName' ORDER BY Roles.Name
Hi Nick, do you mean the new functions in App Engine, or are there also new functions in App Studio?
