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

© 2016 Microsoft