Re: SQL0552 Not authorized to DROP PROCEDURE.

In case you care, on a system created new at 7.2, with very little 'system
type' modifications, and recently upgraded to 7.3 shows
Object . . . . . . . : SYSROUTDEP
Library . . . . . : QSYS2
Object type . . . . : *FILE
Object
User Group Authority
*PUBLIC *CHANGE
QSYS *ALL

And, once again, only certain IBM API's can update it, irregardless of
your individual authority.
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : No
Allow update operation . . . . . . . . . . : ALWUPD *NO
Allow delete operation . . . . . . . . . . : ALWDLT *NO
So, even if you had *ALLOBJ, *SECADM, *IOSYSCFG, etc you still couldn't
run UPDDTA against it and add, change or delete rows.

Whomever is messing with security seems to have executed the Al Barsa
MAKEAMESS command.

If it was truly intentional there just has to be a better way to lock down
sql access.

Rob Berendt