dbTalk Databases Forums  

Security problem - deleting 1000 user ids

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


Discuss Security problem - deleting 1000 user ids in the microsoft.public.sqlserver.olap forum.



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

Default Security problem - deleting 1000 user ids - 08-27-2003 , 10:34 AM






I have moved a cube to my laptop for testing, but have over 1000 users over
several cubes. These slow down processing and I would like to remove them
all, but it takes 10 minutes to remove one user at a time. I wanted to
highlight the entire list and press delete, from within Manage Roles in
Analysis Manager, but this is not possible. Does anyone have any
suggestions on how I could remove all of them at once?

Thanks

--



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/18/2003



Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Security problem - deleting 1000 user ids - 08-28-2003 , 07:32 PM






"sal" <lambl6666 (AT) hotmail (DOT) com> wrote

Quote:
I have moved a cube to my laptop for testing, but have over 1000 users
over
several cubes. These slow down processing and I would like to remove them
all, but it takes 10 minutes to remove one user at a time. I wanted to
highlight the entire list and press delete, from within Manage Roles in
Analysis Manager, but this is not possible. Does anyone have any
suggestions on how I could remove all of them at once?
You can try to write simple DSO script which makes UserList on the Role
empty.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================




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.