Setting Permissions from isql

Use the isql to grant permission.

The ECDA service used to issue GRANT EXECUTE command must be in sybase mode for SQL transformation (SQL transformation is an access service property with one of two settings, passthrough or sybase). To ensure this, enter this command before you issue GRANT EXECUTE command:

set sqltransformation sybase

Issue:

GRANT EXECUTE ON PACKAGE SYBASE.DEF000x TO PUBLIC

Because the AS/400 allows you to change security levels and ownership of objects, you can use another user ID to create the SYBASE collection. For example, you can use one ID to create the SYBASE collection, then grant other users create and execute authorization for the collection and its objects.

You can create the SYBASE collection in one of:

If you have DB2 (or DB2/400) Query Manager and SQL Development Kit (SDK) installed on the AS/400, you can run the SQL utility using a 5250 session.
If not, use the AS/400 SEU utility program to create the SYBASE collection.