Hi,
I just wanted to know what rights as a user one would need in order
to edit/process a cube which is on an external 2005 Analysis Server.
Right now my user is part of the SQLServer2005MSOLAPUser$Machine
Name$MSSQLSERVER group on this server.
I am able to connect to thsi server through SQL Server Management
Studio., but I dont see any analysis services databases under it.
Thanks
In AS 2005 you manage security through the database roles, not by OS security groups. This is change from AS2000. I am guessing you are current AS2000 user and trying apply the same logic.
To grant processing rights. Create a database role, add your user and grant the role youve created processing rights to the cube. This should be pretty straightforward.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment