- 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.
推薦閱讀
- Python程序設計教程（第2版）
- DevOps with Kubernetes
- aelf區塊鏈應用架構指南
- C語言程序設計案例式教程
- Python高效開發實戰：Django、Tornado、Flask、Twisted（第2版）
- Spring核心技術和案例實戰
- Terraform：多云、混合云環境下實現基礎設施即代碼（第2版）
- 執劍而舞：用代碼創作藝術
- IBM Cognos Business Intelligence 10.1 Dashboarding cookbook
- Python3.5從零開始學
- 打開Go語言之門：入門、實戰與進階
- R數據科學實戰：工具詳解與案例分析
- JBoss：Developer's Guide
- 從程序員角度學習數據庫技術（藍橋杯軟件大賽培訓教材-Java方向）
- Android Studio開發實戰：從零基礎到App上線 （移動開發叢書）