Is there anyway to add users as Collection admin by inserting in mongodb directly?

[skaps]

Hi,

we have several collections ion our enterprise, now I want to add some more users as admin to those collections. as we all know the common way to grant collection admin is to add myself(owner of the collection) and the users to the corresponding subscription and then add the users as admin to those collections. Is there any way we can simplify this and can do that by inserting into Alteryx MongoDB directly and if there is any way can you please share the script?

Another query we have some collections whose owners already left the company so I want to know the process of adding other users as admin to those collections.

it's very urgent. Thanks a lot in advance to all.

[KaneG]

Hi @skaps,

It's not possible to insert directly into the Mongo. There is a lot of relationships that would need to be managed in the 3 DB's and so the work that would be needed to develop and test that would far outpace the work to manually add users or add via AD Groups.

[skaps]

Hi @KaneG ,

Thanks a lot for your quick response.

It is a very tedious task to do that. but as of now, this feature is not there we have to do that manually :(.

Anyway, can you please tell how I can add users as admin for the collection where I am not the owner of.

[KaneG]

Admins of the collection have to be in the studio. Only Admins can add other Admins.

[skaps]

i am unable to add other users aas admin being admin of those collections.

[KaneG]

Those users would need to be in the same Studio/subscription as the admin of the collection. So, if you are admin of Collection X, any other users that you try and assign to be admin of Collection X also need to reside in the same subscription as you.

[skaps]

i am doing the same thing. I am an admin of collection X. to add the user as admin of that collection x i first added the owner of that collection to the X subscription and then added myself and the user but also not able to add user as admin to that collection x.

Am i missing something?

[KaneG]

The order things are done is important. If you add yourself to a subscription, but you were already an admin of a collection, you may lose admin rights to that collection. I can't say for sure as it's getting into a direct case and so without seeing it directly, I'm not sure the issue...

[skaps]

okay. i will log a case with Alteryx support guys.

[AntonioKeyrus]

Hi skaps,

Did you solved this issue with Alteryx support team? Can you share what was the solution?

I am facing same issue, UserA owner of CollectionA assigned to PrivateStudioA, UserB set as admin of CollectionA and assigned to same PrivateStudioA. UserB can manage the collection as admin but not able to add other users with admin role.

Issue detected in Alteryx server 2018.3

Thx!