Skip to Content

Identity center.Modify table MXIV_SENTRIES

Hi,

In Identity center , We would like to create a pass to modify/delete data in Identity center . We were trying to modify values for some of the Attributes of MX_PRIVILEGE .

In that pass , we included source as "From databse" and selected From Identity store check box. then gave a SQL Query to get the records satisfying a condition . then in destination we chose MX_PRIVILEGE , and gave

MSKEYVALUE %MSKEYVALUE%

changetype modify

SYSID <NEW VALUE>

We could modify SYSID but could not modify MSKEYVALUE(Is it used as primary key here?) . please advise how to do that.

How can I use efficiently the changetype attribute in my pass. where it needs to be included in the destination tab.

If you have someother solution for this also ,please let me know.thanks

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 02, 2009 at 08:10 PM

    It's never a good idea to affect the database views or tables (MXIV_SENTRIES is a view by the way)

    Just so you know however, MSKEYVALUE is not the primary Key, rather MSKEY is.

    I think you might want to reconsider how you are modifying the privilege, which are usually associated with Roles in IdM.

    If you spell out your use case a little better, we might be able to come up with some recommendations.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Srilakshmi S

      Your best bet is to edit the entries already in the system, if all you want to do is rename their MSKEYVALUE.

      Take a look at this link:

      /people/matthew.pollicove/blog/2009/03/19/renaming-the-nw-idm-mskeyvalue-attribute

      I wrote it with MX_PERSON entries in mind, but there is no reason it would not work for other entry types.

      Hope this helps,

      Matt