Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Roles Property

Roles Property

SQL Server 2000

Roles Property

This property specifies a comma-delimited string of the role names under which a client application connects to the server.

Property Name


Property ID



This property allows the user to connect using a role other than the one he or she is currently using. For example, a member of the OLAP Administrators role may want to connect to a cube as a member of the Users role to test permissions granted to the Users role. This user must be a member of the role specified in order to connect using this property.

Important  Role names are case-sensitive, and spaces should not be used between the comma-delimited role names. Otherwise errors and unexpected results may be returned as a result of queries to secured cell sets.

See Also

User ID Property

Password Property

© 2015 Microsoft