Grants permission to other users to use QAnywhere stored procedures.

Parameters

Remarks

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.

See also

• Setting up SQL applications

Example

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

call dbo.ml_qa_grant_messaging_permissions( 'user1' )