the best practice to update user access frequently

[#1]

Hi,

I am an user of v8.5 and I need to update user access at least three times a day.

But I have more than 30 million rows of data and afraid to refresh Fact table all the time.

What will be the best practice to update section access?

Thanks in advance!

Ryan

[rwunderlich]

Are you using NTNAME for section accees security? If so you can specify AD Groups instead of Userids. Then add or subtract users from the AD groups without reloading the document.

-Rob

[#3]

Or you could take a copy of the report and binary load the data from the old with only section access in it.

/Michael

[#4]

That is what we are currently using. Is this method safe ?

I implemented binary load and section access in hidden script which is binary into datamodel.qvw files.

I am facing some minor issues with security (security table and some other tables are not updated correctly) and I like to know whether binary load with security is a certified method to work with.

Is there anyone else who is using this method?

Ryan