dbTalk Databases Forums  

Disable Access

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Disable Access in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Yash
 
Posts: n/a

Default Disable Access - 12-12-2004 , 12:29 AM






Hi,
Is there any other way to disable access to data for cube for a specified
date range other than Cube Roles.
--
Regards,
Yash


Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Disable Access - 12-12-2004 , 08:56 AM






First, you cannot apply security without roles.

Second, I understand this:
you want to restrict the user to a particular subset of date in your cube(?)
so you want to restrict the access of the time dimension to only particular
members, which can be done through roles + dimension security.
Then simply check the members you want to allow access (or disallow members
you don't want to provide any access)

"Yash" <Yash (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:
52E13325-F488-4C39-B10F-A9CE92568FBC...soft (DOT) com...
Quote:
Hi,
Is there any other way to disable access to data for cube for a specified
date range other than Cube Roles.
--
Regards,
Yash




Reply With Quote
  #3  
Old   
Igor Mekterovic
 
Posts: n/a

Default Re: Disable Access - 12-13-2004 , 04:19 AM



I would also like to suggest to check out the dynamic security.
Here is one link to get started, there are many more on the web (also, look
in groups):
http://support.microsoft.com/default...wctd090303.asp
Regards,
Igor

"Yash" <Yash (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
Is there any other way to disable access to data for cube for a specified
date range other than Cube Roles.
--
Regards,
Yash




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.