copy security groups ! urgent | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

copy security groups ! urgent

I 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
yukon dba

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:


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |