topic Update PIN enduser - No UPDATE permission for credential in IP Telephony and Phones

Update PIN enduser - No UPDATE permission for credential

mischm — Sun, 17 Mar 2019 01:29:50 GMT

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?

Michae

Update PIN enduser - No UPDATE permission for credential

dojoy — Fri, 26 Jul 2013 11:29:50 GMT

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..

Update PIN enduser - No UPDATE permission for credential

mischm — Mon, 16 Sep 2013 12:40:06 GMT

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"?

Michael