copy security groups ! urgent | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
copy security groups ! urgentI need to copy the security groups from production to stage ,as users are not able to access the cube online…
( note :the production server is analysis sercvices 2000 and the stage server is analysis services 2005)
any ideas ? thanks in advance
In SQL 2000, I would use the script generation wizard twice.
For the first script you select the Script All Objects option, then deselect all Formatting Options, and select those Security Scripting Options that you need.
For the second script, you do not select any object at all, then for formatting you select the CREATE command only, and for the Security Scripting Options you select the ones that you need.
You need to run the second script before the first one. Test this on a copy of the production database, before implementing.
Please post your question in relevant forum section only.
With the updated books online for SQL 2005 there is a section "Securing Analysis Services " that explains the information: