SQL Admin Provider::AddUserToRole

The AddUserToRole method allows you to add a user to a SQL role.

Arguments

Remarks

Sample Code

Example XML Request

The following is an example of an XML request for the AddUserToRole method:

<?xml version="1.0" encoding="iso-8859-1" ?> 
<request>
	<data>
		<name>SampleSQL01_User</name>
		<role>db_Owner</role>
		<database>SampleSQL01</database>
		<serverName>SQL01</serverName>
		<sqlUserName>sampleUser</sqlUserName>
		<sqlUserPass>Pass1Word</sqlUserPass>
	</data>
	<procedure>
		<execute namespace="SQL Admin Provider" procedure="AddUserToRole">
		<before source="data" destination="executeData" mode="merge"/>
		<before source="executeData" destination="data" mode="insert"/>
		</execute>
	</procedure>
</request>

Example XML Response

The following is an example of the structure of an XML response for the AddUserToRole method. The actual returned data will be filled in within the <data> nodes:

<?xml version="1.0" encoding="iso-8859-1" ?> 
<response>
	<data></data>
</response>

Applies To