Only users with DBA privilege automatically have permission to execute the QAnywhere stored procedures. Other users must be granted permission by having a user with DBA privileges run this stored procedure.

This procedure adds the user to a group called ml_qa_message_group and gives them execute permissions on all QAnywhere stored procedures.

• Setting up SQL applications

For example, to grant messaging permissions to a user with the database ID user1, execute the following code:

call dbo.ml_qa_grant_messaging_permissions( 'user1' )