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