DB2 Security Commands

Build a script to grant user execute privilege on all packages.
=>db2 "select 'db2 grant execute on package '||pkgschema||'.'||pkgname||' to user ;' from syscat.packages where pkgschema = 'NULLID'" > output.file

Security Notes

• dbadm auth must be revoked before any other database privlege.
• create_not_fenced_routine must be revoked before create_external_routine