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.
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' ) |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |