Submitted By: ded
ANY user can drop procedures, generators, exceptions.
Tables, indices and triggers are not affected. To
1. Connect as SYSDBA
2. Create Procedure Test As Begin Exit; End
3. Disconnect and connect as any user
4. Drop Procedure Test - successfully.
Interesting is the next: if before step 4 try to
Execute Procedure Test
exception 551 will be raised and after it step 4 will
raise expected exception 607 - unsuccessful metadata
update -ERASE RDB$PROCEDURES failed -no permission for
delete access to PROCEDURE TEST.
Confirmed on builds WI-V126.96.36.1994, LI-V6.2.796.
Best regards, Alexander V.Nevsky.