You can restrict access to data managed by Microsoft® SQL Server™ OLAP Services via the security features. Using security features, you can control who has access to data and the types of operations they can perform with the data. OLAP Services supports a Microsoft Windows NT® integrated security system and allows you to assign access permissions at the database and cube (including virtual cube) level.
Security is controlled via access control rights that are managed using roles. Access control rights determine the type of access to data. Roles define categories of users with the same access control.
Note Access control rights are enabled only if the server is installed on the Windows NT NTFS file system, which enforces access control lists (ACLs). Access control rights cannot be enforced on a file system such as file allocation table (FAT) that does not support ACLs.
Topics in this section cover: