Attempting to drop or alter a procedure on a query server after upgrading from 12.5 to 12.6 returns a “permission denied” error.
To DROP or ALTER PROCEDURE on a multiplex upgraded to Sybase IQ 12.6, perform the following steps:
On the write server, recreate the procedure. This overwrites the query server’s version. For example:
CREATE PROCEDURE quarterly_results
On the write server, drop the procedure, for example:
DROP PROCEDURE quarterly_results