DB2 Security Commands
BASIS
,
DB2
,
MSSQL
,
SAP Beginners
No comments
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
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment