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
=>db2 "select 'db2 grant execute on package '||pkgschema||'.'||pkgname||' to user
Security Notes
- dbadm auth must be revoked before any other database privlege.
- create_not_fenced_routine must be revoked before create_external_routine
No comments:
Post a Comment