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