dbTalk Databases Forums  

AS2005: Dynamic Security cache duration?

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


Discuss AS2005: Dynamic Security cache duration? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default AS2005: Dynamic Security cache duration? - 07-06-2006 , 09:37 AM






Hi,

I have created a stored procedure to generate a set of authorized customer
from my database.
This works fine.

Now I want to know how many time AS keep this security in cache?
how to reset it?

when I update the security table, I want to reset the security cache in my
database.

thanks.

Jerome.



Reply With Quote
  #2  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: AS2005: Dynamic Security cache duration? - 07-07-2006 , 11:20 PM






You could call ClearCache -- it should clear the security cache as well...

HTH,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
Hi,

I have created a stored procedure to generate a set of authorized customer
from my database.
This works fine.

Now I want to know how many time AS keep this security in cache?
how to reset it?

when I update the security table, I want to reset the security cache in my
database.

thanks.

Jerome.





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.