SQL Admin Provider::GrantDBAccess

The GrantDBAccess method allows you to grant access to a SQL account for a particular database on a Microsoft Windows NT or Microsoft Windows 2000 server. This adds the user to the public role for that database. This is separate from the AddUserToRole and RemoveUserfromRole methods, because they do not reliably affect the public role. If the user is a SQL user account, the user must already have been granted access to the SQL server by means of AddLogin. If the user account is a Windows NT or Windows 2000 account, it is not required to call GrantLogin prior to issuing this call.

Arguments

Remarks

Sample Code

Example XML Request

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

<?xml version="1.0" encoding="iso-8859-1" ?> 
<request>
	<data>
		<name>SampleSQL01_User</name>
		<database>SampleSQL01</database>
		<serverName>SQL01</serverName>
		<sqlUserName>sampleUser</sqlUserName>
		<sqlUserPass>Pass1Word</sqlUserPass>
	</data>
	<procedure>
		<execute namespace="SQL Admin Provider" 
		 procedure="GrantDBAccess">
		<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 GrantDBAccess 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