Is it possible to query and get list of members of a role using XMLA?
In AS 2005 an administrator can do this. But it is not a part of the standard. Thanks, Akshai -- -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message news:efAV3X0MGHA.2040@TK2MSFTNGP14.phx.gbl... > Is it possible to query and get list of members of a role using XMLA? >
Thanks Akshai. Could you give an quick example of how this would be done in AS 2005. Or a pointer to the relevant areas in documentation. Chris "Akshai Mirchandani [MS]" wrote in message news:eTQ7ei$MGHA.3284@TK2MSFTNGP14.phx.gbl... > In AS 2005 an administrator can do this. But it is not a part of the > standard. > > Thanks, > Akshai > > -- > -- > This posting is provided "AS IS" with no warranties, and confers no rights > Please do not send email directly to this alias. This alias is for > newsgroup > purposes only. > > "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message > news:efAV3X0MGHA.2040@TK2MSFTNGP14.phx.gbl... >> Is it possible to query and get list of members of a role using XMLA? >> > >
You would do a DISCOVER_XML_METADATA (http://msdn2.microsoft.com/en-us/library/ms126291.aspx) and specify the RoleID as a restriction (and the DatabaseID also). This would return you a description of the DDL of that role and you can look at the Members collection for the list of members. See http://msdn2.microsoft.com/en-us/library/ms126711.aspx and the Roles section there for an idea of the response. This isn't normally what people would do though -- most people should be using AMO to do this. Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message news:uxYqpMjNGHA.812@TK2MSFTNGP10.phx.gbl... > Thanks Akshai. Could you give an quick example of how this would be done > in AS 2005. Or a pointer to the relevant areas in documentation. > Chris > "Akshai Mirchandani [MS]" wrote in message > news:eTQ7ei$MGHA.3284@TK2MSFTNGP14.phx.gbl... >> In AS 2005 an administrator can do this. But it is not a part of the >> standard. >> >> Thanks, >> Akshai >> >> -- >> -- >> This posting is provided "AS IS" with no warranties, and confers no >> rights >> Please do not send email directly to this alias. This alias is for >> newsgroup >> purposes only. >> >> "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message >> news:efAV3X0MGHA.2040@TK2MSFTNGP14.phx.gbl... >>> Is it possible to query and get list of members of a role using XMLA? >>> >> >> > >
Thanks Akshai. I know AMO would be better - but I always like to know if and how to use XMLA. Chris "Akshai Mirchandani [MS]" wrote in message news:uCtdO0kNGHA.3936@TK2MSFTNGP10.phx.gbl... > You would do a DISCOVER_XML_METADATA > (http://msdn2.microsoft.com/en-us/library/ms126291.aspx) and specify the > RoleID as a restriction (and the DatabaseID also). This would return you a > description of the DDL of that role and you can look at the Members > collection for the list of members. See > http://msdn2.microsoft.com/en-us/library/ms126711.aspx and the Roles > section there for an idea of the response. > > This isn't normally what people would do though -- most people should be > using AMO to do this. > > Thanks, > Akshai > -- > This posting is provided "AS IS" with no warranties, and confers no rights > Please do not send email directly to this alias. This alias is for > newsgroup > purposes only. > > "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message > news:uxYqpMjNGHA.812@TK2MSFTNGP10.phx.gbl... >> Thanks Akshai. Could you give an quick example of how this would be done >> in AS 2005. Or a pointer to the relevant areas in documentation. >> Chris >> "Akshai Mirchandani [MS]" wrote in message >> news:eTQ7ei$MGHA.3284@TK2MSFTNGP14.phx.gbl... >>> In AS 2005 an administrator can do this. But it is not a part of the >>> standard. >>> >>> Thanks, >>> Akshai >>> >>> -- >>> -- >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights >>> Please do not send email directly to this alias. This alias is for >>> newsgroup >>> purposes only. >>> >>> "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message >>> news:efAV3X0MGHA.2040@TK2MSFTNGP14.phx.gbl... >>>> Is it possible to query and get list of members of a role using XMLA? >>>> >>> >>> >> >> > >
