DB2 Security

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 <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