Designing and creating security roles in an OLAP database (Intermediate) begins with security management with a design and creates phases that are initial steps to defining the security roles, irrespective of relational database type or analytical database type.

Creating security roles (Intermediate) covers the topic where, in order to manage security for Analysis Services objects and data, a role is important. This associates relevant operating system security identifiers that will build a much more robust system.

Defining dimension access privileges (Advanced) will look through dimension access privileges. As an administrator, your responsibility is to grant relevant read or write permissions to some or all members of any dimension in the cubes to which the database role has access permissions.

Managing role-based security – database to cube level (Advanced) will look at how to grant access and permissions from the database to cube level within an Analysis Services database.

Managing role-based security – dimension to cell level (Advanced) will look through how to grant access and permissions from the dimension to cell level within an Analysis Services database.

Accessing restrictions on dimensions and defining default members – full and partial (Intermediate) lets us overview access restrictions and define the default members with necessary permissions.

Securing data at the cell level (Intermediate) will look through the key steps in securing data at the cell level within a cube.

Preventing read/access to cell data (Intermediate) highlights the essential steps to limit the cell data access within the cube or dimension that will explicitly restrict cell access.

Managing user-access privileges on a cube (Advanced) will look through the user-access privileges on the cube.

Managing security roles for processing (Intermediate) explains the important security roles that are essential for cube processing.

Data source and access control on cubes (Advanced) will go through the key aspects on how the access control can be affected to the data sources and dimension data that are included in the cube.

Building secure BI platform – the journey from SQL Server 2008 R2 to 2012 (Intermediate) provides an explanation of what it takes to build a secure BI platform with highlights on enhancements to the product while transitioning from SQL Server 2008 R2 to 2012. In this recipe, we will go through the important aspects in building a secure BI platform on the instance level along with enhancements that are incorporated in SQL Server since version 2008 R2.

Securing key points in SSAS (Advanced) provides an addition to the previous recipe on securing the key points within a SSAS instance that are associated outside of the SQL Server instance.

In order to fulfill the criteria, we need the following prerequisites for the book:

This book is aimed at helping the key people in the data platform administration and management world, such as Data Architects, Developers, and Aspiring Database Administrators.

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "A full set of properties can also be found in the msmdsrv.ini file."

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Click on the Dimensions option in the Select a Page pane."

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to <[email protected]>, and mention the book title via the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.