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.