User Group dissapeared after change in security

Hi Gurus,

Messed with user security on a user group and now I am not able to see it. When I try to create another group with same name it says the group already exists - (FWB 00026) .
This is what I did: Unchecked the “Inherit from Parent folder” and also the “Inherit from Parent Group” - it did not have any other permissions. I hit okay to dismiss the warning message and that was the end of it. :hb:
As administrator, I am not able to view the group and don’t know how to reset the permissions. The database (SQL) is encrypted and I could not figure out where this group resides so I may delete it there.

Is there any way I can see and access the group again or re-set permissions? Request your help / suggestion on this please.

[EDIT]
This missing user group is so frustrating - not able to see it with admin login nor is it showing up when I use the query builder. Yet it is not allowing me to create a new user group with the same name!

If only I can see the group, i can reset the permissions. Any help on this is greatly appreciated. Thanks a lot.

BTW, the query, in-case someone might need it:
Select * from CI_SYSTEMOBJECTS Where SI_KIND=‘UserGroup’


Leo9 (BOB member since 2005-12-14)

Still researching this issue and also waiting for a response from SAP. Not sure if they will respond to “unregistered” users.

Lot of interesting information out there in various forums - but nothing is close to resolving this problem. I must say BOB has a wealth of useful information and is the best forum.


Leo9 (BOB member since 2005-12-14)

Make sure you are logged in as “Administrator”, and not just as a user in the Administrators group.


joepeters :us: (BOB member since 2002-08-29)

Thank you, joepeters.

Nope - logging in as admin also does not help to “reveal” this missing group.


Leo9 (BOB member since 2005-12-14)

if you try to ‘join’ a group, do you see this in the list to join? Maybe adding yourself would help.

B


bdouglas :switzerland: (BOB member since 2002-08-29)

Have you tried a QueryBuilder search by name? Perhaps the type got messed up somehow.

Do you happen to recall what rights you were messing with? It’s strange that Administrator has no rights. I was under the impression that it was exempt from denies.

Familiar with the SDK? You may be able to programmatically delete it if there are any groups/IDs that still have rights to it.


ChrisW1204 :us: (BOB member since 2011-04-21)

Hi bdouglas, I did try to join group - no luck - could not see the group.

ChrisW1204, I could not find the group via the query-builder. And No - I dont have SDK knowledge…

I seem to have broken the inheritance by un-checking both the Inherit from parent folder and Inherit from parent group - navigated to this from applications --> Web intelligence --> User Security and then selecting Assign Security.

Thank you for looking into this.


Leo9 (BOB member since 2005-12-14)

Hi,

In this case, kindly log into CMC through Administrator account and password. This issue comes due to the Administrators group access has been removed from Parent folder or Subfolder.

I was also facing the same issue. The folder suddently disappear when I was applying security on parent folder.

Then I logged in to CMC through Administrator account check the security on parent folder because the hidden folder can visible in Administrator account. So, I verified the security on folder and there I found Administrator Full Control access has been missing. So, I re-applied this security on this folder. Then I was able to see this folder through my ID.

Hope this will help you to fix your issue.

Thank you,


sandeep.gore (BOB member since 2011-08-28)

Had the same problem but I don’t have access to the administrator user.

There is any workaround to this problem?


balrog687 (BOB member since 2011-12-27)

Hi Leo,

sorry, I don’t get it completely.
You set the permissions for Webi (as Application)?

then you selected the group in question (GROUPXY) and clicked “assign security”, removed both ticks for inheritage and said ok?

this should not have any effect on you being able to see the group as an admin, it would normally just say “GROUPXY - No Access” in the User Security list for Webi.

the effect you describe could only happen when you remove the Administrators group from being able to see the GROUPXY, hence in the Users/Groups folder choose the User security of the group itself. Then you would end up with
“Administrators / No Access” on the group.

However, with the (builtin!!) Administrator user I can still see such a group (just tested). When I use a different account that is in the Administrators group the group is indeed not visible.

So maybe something else happened there?
Which BO Version are you on?

cheers
MU
:mrsbob:


Miss Universe :de: (BOB member since 2010-02-16)

Obrigado, conseguir visualizar o grupo sem acesso(Oculto para outros usuários) através do usuário Administrator. :smiley:


emerson.bonneterre (BOB member since 2018-08-23)