Capture Create Procedure Warnings in SQL Assistant

Tools & Utilities
Highlighted
Junior Supporter

Capture Create Procedure Warnings in SQL Assistant

How can we capture or see create procedure Warnings in SQL Assistant like we do in BTEQ.

 

e.g. If I create a SP with SQL SECURITY DEFINER and if the OWNER does not have sufficient rights then during compilation the Database will raise Warnings which are not seen in SQL Assistant. I only come to know about the rights issue when I exceute the procedure.

 

However if I compile the procedure using BTEQ the Warnings are displayed.