Modifying package authorizations
For any programs created on i5/OS®, you can change the users that are authorized to use that package. This can be done using SQL's GRANT and REVOKE statements:
- GRANT ALL PRIVILEGES ON TABLE table-name TO user (possibly PUBLIC for user)
- GRANT EXECUTE ON PACKAGE package-name (usually the i5/OS program name) TO user (possibly PUBLIC for user)
It can also be done entering GRTOBJAUT and RVKOBJAUT commands from the command line.
Parent topic:
Managing an SQL package