Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » QAnywhere » QAnywhere API Reference » QAnywhere SQL API reference » Message management



Grants permission to other users to use QAnywhere stored procedures.

Item Description Remarks
1 Database user ID VARCHAR(128)

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

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' )