O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Securing Administrative Access

Within Analysis Services, administrative rights are assigned at two levels. The broadest administrative rights are granted through the built-in server role. More limited rights are assigned through custom database roles. In the sections that follow, you will explore the use of these roles to assign appropriate administrative access within Analysis Services.

Assigning Server-Level Administrative Access

Analysis Services comes preconfigured with a single, server-level role. This role, referred to as the server role, is the only server-level role permitted within Analysis Services, and it cannot be dropped or modified beyond changes to its membership.

The server role has full administrative rights within Analysis Services, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required