The mission of the Security Virtual Chapter is to provide guidance and education, and to foster open discussion on security topics as they pertain to SQL Server and its environment.

Welcome to the PASS Security Virtual Chapter

Security is hard, and is hardly convenient - yet in today's world, it becomes absolutely necessary. Security touches upon infrastructure, code, and even things in the "physical" world. It is much more than Administration and Development.

The Security Virtual Chapter will cover the following topics and much more:
- SQL Server surface area and Attack vectors (SQL injection, etc)
- Encryption
- Security standards and best practices
- Forensics
- Audits and regulatory compliance
- Authentication and authorization

Analysis Services Security
Presenter:Stacia Misner
Date: Thurs, April 23, 2015 10:00 AM - 11:00 AM PDT

Because an Analysis Services multidimensional database is secure by default, security must be configured before users can query cubes. In this session, we review how to configure roles for user access and how to restrict what users see. In addition, we will explore techniques for advanced security scenarios, including data-driven security on standard and parent-child dimensions and permissions for writeback of cell and dimension data. Last, we will cover administrator security to control access to Analysis Services at the database and server level.

Presentation level: 200

Speaker bio:
Stacia Misner is a SQL Server MVP, SSAS Maestro, MCIT-BI, and MCTS-BI with a Bachelor’s degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 25 years, with a focus on improving business practices through technology. Since 2000, Stacia has been providing consulting and education services for Microsoft's Business Intelligence technologies. During that time, she has also authored several books covering the Microsoft BI stack.

For updates on future meetings and events, follow us on Twitter at @PASS_SecurityVC.