Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 MS SQL 7.0 OLAP Security Issues

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-17 : 09:05:57
Manoj writes "As per the documentation to enforce security at cube level we need to have a NTFS file system. We have WIN NT 4.0 with NTFS file system and SQL 7.0 with OLAP services.

We need to restrict the access to the cubes with read and read/write permissions. we have creared 2 roles for the same with NTlogin ids.

The problem is that irrespective of the login id, the user is able to process and update the cube. (i.e. user's with read only permissions can update and process the cube."
   

- Advertisement -