I need to remove Idea Manager Auto right for an Idea instance for a user who created the idea:
Any help you will be appreciated.
Auto rights are provided to resources populated in the Manager and Originating Requester fields on the Idea instance. They system defaults Originating Requester to the user who created the Idea. Update that field to remove rights for the user who created the Idea.
Can't you remove him as manager of the idea ?
Yes, he is not the manager of the idea but the creator.
I tried to remove Idea Manager Auto right with this stored procedure but it has no effected.
EXEC CMN_SEC_REMOVE_INST_RIGHT_SP 'USER','JOE','IdeaManagerAuto',5023050;
I am unable to recollect correctly, but I think below can work.
It may be because the created_by field in database table still holds the creator information. I think for your use case, replace below with admin
Also, backup the original creator to some custom field.
Another option would be try using IDEA XOG and see if you can find the attributes such as initiator etc so that DB changes can be avoided.
Please test the above only in DEV and by the way, I hope you know the consequences doing direct DB changes.
Thank you all for your answer.
Retrieving data ...