[cisco-voip] UCCx 10.5 custom stored procedure for reporting

Brian Meade bmeade90 at vt.edu
Fri Apr 8 11:28:17 EDT 2016


I use AGS Server Studio as well.  This is how I do it and make sure the
permissions are okay:

DROP FUNCTION sp_exec_summary(datetime,datetime,integer,lvarchar);

CREATE FUNCTION sp_exec_summary (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_appNameList LVARCHAR(4000) DEFAULT 'NULL' )
END FUNCTION;

grant execute on function
sp_exec_summary(datetime,datetime,integer,lvarchar) to 'public';


AGS Server Studio tries to add 'uccxhruser' in front of the stored
procedure names.  I just get rid of those to make sure it's accessible to
everything.

On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley <btalley at gmail.com> wrote:

> Hi all,
>
> Has anyone imported custom stored procedures into the db_cra for use in
> CUIC?  I'm having an issue getting a new stored proc loaded using either
> RazorSQL or AGS Server Studio.  From what I've read, I need to execute the
> stored proc; however, when I do that I get an error that uccxhruser doesn't
> have permission to execute the stored proc.  It seems I can't apply
> permissions to the uccxhruser account on the stored proc until the stored
> proc is loaded.   Would anyone have any tips on how I can go about getting
> the stored proc loaded to the database?
>
> Hopefully this makes sense to someone ;-)
>
> TIA,
> Bill
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160408/a3441f94/attachment.html>


More information about the cisco-voip mailing list