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
Is the security account being added to the database. The value
for security_account is SYSNAME, with no default. The
security_account can be any valid SQL Server user, SQL Server role,
or any Windows NT user or group granted access to the current
database. When adding Windows NT users or groups, specify the name
that the Windows NT user or group is known by in the database.
The database that the user should be granted access to.
A string representing the name of the server. This can be a
NetBIOS name, a FQDN, or an IP address. It is vital that the server
upon which MPS is running be able to resolve server names using
whichever naming convention you employ.
The user name for connecting to the SQL server via SQL
Authentication. If this node is present the connection will be made
via SQL Authentication rather than Windows Authentication. The
existence of this node also requires that the <sqlUserPass/>
The password for connecting to the SQL server via SQL
Authentication using the username indicated by
<sqlUserName/>. If the <sqlUserName/> node is not
present, this node is ignored.