Skip to Content
0
Former Member
Jun 18, 2009 at 03:51 AM

Dynamically Adding Universe Restrictions

22 Views

I have 300 DBs

All have the same structure

My tenative process is to build a Universe.

Then add 300 Restrictions ; attaching each restriction to a named user account (which represents the DB)

My question: how can i programatically do this? in C#

The steps in designer are:

Tools > manage security > add restirction > filter for specific connection > add--> apply to user account with same name

Anything would help-- i have been scouring the web/the object viewer and cant find a way to do this...

-Dave Butz