If the cube is then visible in the browsing window, the specified user (or role user) will be able to view the cube using ZAP BI. Right-click the cube, and select Browse from the menu that appears.Įnter a user, or check a list of roles to check for verification. Under the database, expand the Cube node. To ensure that one or more of the intended users has access: When finished, click OK, then click OK again to close the role. Step 3: Create a database user In SQL Server Management Studio, right-click Security > Logins then select New Login. On the General page, give the role a relevant name, and assign the Read definition permission for the role.Ĭlick the Membership page, and click the Add button to specify the users or groups which will have "read" access to the cube.Ĭlick the Cubes page, click the drop-down list in the cube's Access column, and select Read. Open SSMS, and connect to your SQL Server Analysis Services server:Įxpand the relevant database, right-click the Role node, and select New Role.: Right-click the Databases folder and chose New.
Open the database server in the Object Explorer (left panel). To create a cube role in SQL Server Management Studio (SSMS): Procedure Open SQL Server Management Studio. Tip: For more information, refer to Security Migration. However, for Microsoft SQL Server Analysis Services generic cubes, no security is imported (since no roles are assigned to tables in SQL Server), and all security must be manually configured. You are here: Reference Information > Troubleshooting > Create a Role in SQL Server Management Create a Role in SQL Server Management Studioįor Microsoft Dynamics data sources, application users and security settings are migrated to the cube.
0 kommentar(er)
