Update PIN enduser - No UPDATE permission for credential

[mischm]

Hi,

how can I set / update a new PIN via SQL for a enduser which is used for extension mobility?

I tried this command:

update credential set credentials='new pin' where fkenduser='pkid from enduser' and tkcredential='4'

and get this reply: No UPDATE permission for credential.

Our CUCM is LDAP integrated but enduser pin is editable via CUCM webpage.

How can I update this enduser pin via SQL?

BR

Michae

[dojoy]

I do not think thats possible unless you have root access to the CUCM.

Reason: here is an ouput from CUCM DB; copy paste the below on a notepad your will understand much better..

admin:run sql select * from enduser where userid = "test"

pkid                                 assocpc firstname middlename lastname userid manager department telephonenumber tkuserlocale mailid status facsimiletelephonenumber mobile pager homephone title building site fkdirectorypluginconfig uniqueidentifier nickname deletedtimestamp passwordreverse fkmatrix_presence                    tkuserprofile fkcallingsearchspace_restrict allowcticontrolflag enablemobilevoice maxdeskpickupwaittime enablemobility remotedestinationlimit ocsprimaryuseraddress enableemcc fkucserviceprofile directoryuri islocaluser fkfeaturegrouptemplate

==================================== ======= ========= ========== ======== ====== ======= ========== =============== ============ ====== ====== ======================== ====== ===== ========= ===== ======== ==== ======================= ================ ======== ================ =============== ==================================== ============= ============================= =================== ================= ===================== ============== ====================== ===================== ========== ================== ============ =========== ======================

5f7d238c-17cf-345f-fdab-f6b96532242e                              test     test                                      NULL                1                                                                          NULL                                              NULL                             ad243d17-98b4-4118-8feb-5ff2e1b781ac 1             NULL                          t                   f                 10000                 f              4                                            f          NULL                            t           NULL

admin:

Here we do not find a column which has the field PIN.

So inconclution.. you cannot change something that does not exists..

Unless someone can correct me..

[mischm]

You not will find a field PIN in the enduser table because the password / pin is stored in the table "credential".

But when I try to update via SQL update command the "tkcredential" 4 which is the CREDENTIAL_PIN I get back the error message "No UPDATE permission for credential."

As you can see here what tkcredential means:

enum name     moniker

==== ======== ===================

3    Password CREDENTIAL_PASSWORD

4    PIN      CREDENTIAL_PIN

So does anybody knows how to update the field "credentials" in the table "credential"?

BR

Michael