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

SQL Anywhere 11.0.1 (Français) » QAnywhere » QAnywhere Reference » QAnywhere SQL API reference » Message management

 

ml_qa_grant_messaging_permissions

Grants permission to other users to use QAnywhere stored procedures.

Parameters
Item Description Remarks
1 Database user ID VARCHAR(128)
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
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' )