Changing "Owner" of a Portal Navigation Node?

Matt_Overton

I've recently made an effort to better lock down portal access and restrict admin/navigation admin to specific admin accounts.

I've also cleaned up navigation in the portal and scoped access to better reflect who needs what. That being said, there are two pages in navigation that won't vanish for someone's non-admin account - and this I believe is because the person in question was the creator/owner of those nodes, so even though they aren't in any of the groups with permissions, the node won't vanish for this person.

Is there any way I can manually change the owner to their admin account instead? Is there somewhere hidden behind the scenes I can do this?

Peter_Muttenthaler

Hi @Matt_Overton:

I fear the only way to do so is to update the CreatedBy entry to the specific user GUID via SQL code.

You have to do so in the [NavigationNode] table in your Cireson database.

Maybe somebody else have a way better solution ;)

Justin_Workman

@Peter_Muttenthaler is correct here.

UPDATE NavigationNode

SET CreatedBy = '<guid of user>'

WHERE Id = '<Id of NavNode>'

Peter_Muttenthaler

Hi @Matt_Overton:

I fear the only way to do so is to update the CreatedBy entry to the specific user GUID via SQL code.

You have to do so in the [NavigationNode] table in your Cireson database.

Maybe somebody else have a way better solution ;)

Justin_Workman

@Peter_Muttenthaler is correct here.

UPDATE NavigationNode

SET CreatedBy = '<guid of user>'

WHERE Id = '<Id of NavNode>'

Matt_Overton

Perfect thanks both! :)