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

Popular posts from this blog

Jython Script Examples

Skip fields during duplication