You can accomplish the following by embedding SQL in XDS events:
Create database users or roles.
Manage user passwords
You can set, check or modify user passwords.
Manage database user or role privileges.
For examples of each, consult the User DDL Command Transformation style sheet on the Subscriber channel in the example driver configuration.