Clarity

  • 1.  How to remove Idea Manager Auto right to the Idea Requestor

    Posted Sep 29, 2016 04:48 AM

    Hello,

     

    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.

     

    Kind regards,

    Karim



  • 2.  Re: How to remove Idea Manager Auto right to the Idea Requestor

    Posted Sep 29, 2016 05:40 AM

    Can't you remove him as manager of the idea ?

     

    NJ



  • 3.  Re: How to remove Idea Manager Auto right to the Idea Requestor

    Posted Sep 29, 2016 05:42 AM

    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;



  • 4.  Re: How to remove Idea Manager Auto right to the Idea Requestor

    Posted Sep 29, 2016 06:45 AM

    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

    INV_INVESTMENTS.CREATED_BY
    ODF_CA_IDEA.CREATED_BY
    INV_IDEAS.INITIATOR_ID

    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.



  • 5.  Re: How to remove Idea Manager Auto right to the Idea Requestor
    Best Answer

    Posted Oct 04, 2016 05:21 PM

    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.



  • 6.  Re: How to remove Idea Manager Auto right to the Idea Requestor

    Posted Oct 10, 2016 02:35 AM

    Thank you all for your answer.