I need to login to UCCX 11.6 Informix database as dbadmin rights to create a new procedure for a custom report. As far as I know, uccxhruser account which is used for CUIC reporting has readonly rights in db_cra database. When I login to Informix with OpenAdmin Tool, I can see informix and uccxuser account and both have dbadmin rights but we do not have password of these accounts. Do you have any idea how to connect to db_cra as dbadmin ?
Solved! Go to Solution.
Thanks for your kind reply. Does uccxhruser have SP create/update permission on db_cra database ?
As far as I know, it does not have these rights. When I tried to alter the "sp_agent_call_summary" ,I got permission denied error. How can we give this permission to uccxhruser or you meant the user has these permissions by design ?
I have also tried to do it but failed. I have written a very very basic SP but failed to create it. I have also copied and changed the name ,it again failed. Do I need Cisco TAC to create for me a new user or change something on the system which allows uccxhruser to create a new SP ?
İs it related to the below case which requires Cisco TAC ?
Thanks, but that process is also incomplete. I've since figured out a couple of things.
1) there is a bug preventing creation of new stored procedures and TAC involvement is required to work around it.
2) setting the permissions doesn't do anything in regards to installing or deploying the stored proc and the doc you referenced stops at setting permissions.
3) executing the stored proc (once the permissions issue has been resolved) will deploy the stored proc to the uccx database. This is a step which is not documented anywhere is seems to be pretty crucial.
Thanks again for the guidance. I really appreciate it.
thank you very much Jonathan. I was using squirrel sql client for Informix and I have learned today that it has some issues. I tried to create a function with IBM OpenAdmin and managed to create it. Infact, I have still with an issue with creating a customized version of sp_agent_call_summary function. The IBM OpenAdmin and Squirrel gave me sql statement error even if I changed only name of the function. Did you meet this issue already ?