can I Change ct_results() message?

719 Views Asked by At

I am trying to add a login triggers using ASE while following this site , everything is working good. but as below mentionned , i got a ct_result() error , can I change the error ?

CT-LIBRARY error:
ct_results(): network packet layer: internal net 
library error: Net-Library operation terminated due to
disconnect
When this happens, the ASE errorlog will contain a message like:   
EXECUTE permission denied on object my_proc, database my_db, owner dbo

what I want is to change the message to Permission Denied, contact support. can I do that

1

There are 1 best solutions below

3
On

In the link you provided, Rob Verschoor talks about this error message.

1) Do you see any error message in the ASE log file?

2) Did you grant permissions to the my_proc stored procedure such as:?

 grant execute on my_proc to <user/role>
 go

example:

 grant execute on my_proc to public
 go