- Instant SQL Server Analysis Services 2012 Cube Security
- Satya SK Jayanty
- 248字
- 2021-08-13 16:32:04
How to do it...
In order to create security it is essential to create a Windows user and group that will enable the remaining recipes in this book to proceed. Here we will browse through the Windows Server 2008 R2 operating system options.
Once the prerequisites mentioned in the preceding Getting ready section are completed, follow these steps:
- Navigate to Start | Control Panel and choose Administrative Tools, then open the Computer Management (Local) program.
- Expand the
Local UsersandGroupsfolder. - Right-click on Users to create a new user. For the sake of this recipe I have created a user named
DBIA_BI_User. - Right-click on Groups to create a new group, name the group as
BI_User, add the newly created user DBIA_BI_User, and click on OK. - To relate to the preceding steps you should have similar properties shown as per the following screenshot:
- Now the initial requirement of a local user and group on the server is completed, let us jump into SQL Server Management Studio that is specific to Analysis Services instance security.
- Open the SSMS and choose Connect to Analysis Services… (AS) instance.
- Right-click on the selected AS instance and choose Properties.
- Within that Properties page select the Security option that will show the default Server administrators.
Note
Further we can choose the corresponding local or domain group to be part of the Server Administrators role. For the purpose of this recipe we can skip the option of adding any additional group at this moment.
推薦閱讀
- TypeScript Blueprints
- 零基礎PHP學習筆記
- 深入理解Java7：核心技術與最佳實踐
- 可解釋機器學習：模型、方法與實踐
- Hands-On Nuxt.js Web Development
- Learning Ionic
- Appcelerator Titanium：Patterns and Best Practices
- Instant Apache Camel Messaging System
- Go語言入門經典
- JavaScript編程精解（原書第2版）
- Blender 3D Cookbook
- Spring Boot學習指南：構建云原生Java和Kotlin應用程序
- Java程序設計（項目教學版）
- 瘋狂Java講義精粹
- 深入淺出Go語言核心編程