Privileges required for a user to read events using apps adapter

NOrmally in a develoment environment when we create apps apdater then we try to access the events using apps schema.
HOwever in production environment apps user password are not provided and then comes the issue at last moment.

Hence it is better to use a user with limited access from the begining so that at later point of time you do not get issue with access.

First of all create a user READ_ONLY_USER

Following set of queries needs to be executed for the user in order to retrieve events from apps adpater

GRANT ALL ON WF_BPEL_QTAB TO READ_ONLY_USER;

GRANT EXECUTE ON apps.(Package Name) TO READ_ONLY_USER;

This package will contain the procedure and funtions used in your interface.