cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

1586
Views
5
Helpful
5
Replies
Beginner

how to connect to UCCX 11.x Informix db as dbadmin

Hello everyone,

 

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 ?

 

thanks

Sedat

Everyone's tags (5)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: how to connect to UCCX 11.x Informix db as dbadmin

The uccxhruser has create permissions for stored procedures. There is no supported way to get additional permissions beyond that.

View solution in original post

5 REPLIES 5

Re: how to connect to UCCX 11.x Informix db as dbadmin

The uccxhruser has create permissions for stored procedures. There is no supported way to get additional permissions beyond that.

View solution in original post

Beginner

Re: how to connect to UCCX 11.x Informix db as dbadmin

Hi Jonathan,

 

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 ?

 

thanks,

Sedat

Re: how to connect to UCCX 11.x Informix db as dbadmin

You cannot alter a SP that the stock reports depend on. Copy it and create your own.

Highlighted
Beginner

Re: how to connect to UCCX 11.x Informix db as dbadmin

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 ?

 

https://cisco-marketing.hosted.jivesoftware.com/thread/64820?start=0&tstart=0   

"

Correct Answerby  target=_blankbill.talley@umb.com on Apr 20, 2016 7:46 AM

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.

"

Beginner

Re: how to connect to UCCX 11.x Informix db as dbadmin

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 ?

 

thanks,

 

Sedat

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here