Hi,

Due to company policies, we need to have two separate roles to Administered
the Analysis Services (OLAP Administrator) and managing the AS roles. As it
can be done in SQL Server 2000 using the role securityadmin.

Is it possible to do it in AS. If not, do you have any ideas on how to do it?

Thanks in advance.

Unfortunately No. There is a feature in SP4 which allows you to remove the
Administrators local group from the OLAP Administrators local group, but
there is no "role administration" role in AS.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Tiago Rente" <TiagoRente (AT) discussions (DOT) microsoft.com> wrote