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