Hi all,
Ending a huge work on security (directory/namespacecognos/role_groups) i've discovered i'm unable to add a role in a group while this role has been defined at the bottom of a big folder tree. This led me to this topic because i need to update classid on already created Roles (classid 26) to turn them into groups (classid54).
But... while i'm running the following sql against cognoscs the change has no effect on the portal side...
UPDATE [cognoscs].[dbo].[CMOBJECTS]
SET
[CLASSID] = 54 /* instead of 26 */
WHERE [CMID] = the one(s) desired
Any advices ? does the classid for an object stand in an other table also ?
A self reply ...
i'll test restarting the server since i don't think any sql update would lead to a refresh of the server cache.