Migrating Universe/Domain Security?

I would like to know if the Supervisor module supports migrating (copying) existing Row Security defined for one Universe/Domain (ie, Development/Sales), to another Universe/Domain (say Production/Sales)?

Thanks in advance,

Donald May
MIS Eagle Services
Pratt & Whitney
Ph: (860) 565-5253 Fax: (860) 565-4347 M/S: 117-35
E-mail: maydp@pweh.com


Listserv Archives (BOB member since 2002-06-25)

Hi Donald, and listers,

From: May, Donald P.[SMTP:maydp@PWEH.COM] Sent: 18 June 1998 15:18

I would like to know if the Supervisor module supports migrating (copying) existing Row Security defined for one Universe/Domain (ie, Development/Sales), to another Universe/Domain (say Production/Sales)?

Funnily enough, I have just had to do this as we are migrating our repositories from Access (proved VERY unreliable) to OpenIngres.

To do this we have created new domains at the same time as the old ones. On one universe we had extensive row-based security which we didn’t fancy recreating.

I can tell you how I did it, but you must bear in mind that this is unsupported by BO and you must be careful not to corrupt the security domain.

Reply if interested and I’ll send you the SQL I used.

Cheers,

Phil Morris


Listserv Archives (BOB member since 2002-06-25)

Hi Phil.

Thanks for the reply. I would appreciate a peek at the SQL. I’m new to BO and haven’t had the opportunity to mess around in there schema (yet).

Thanks!

From: Phil Morris[SMTP:PIMorris@TARMAC.DEMON.CO.UK]
Sent: Friday, June 19, 1998 5:22 AM

Hi Donald, and listers,

From: May, Donald P.[SMTP:maydp@PWEH.COM] Sent: 18 June 1998 15:18

I would like to know if the Supervisor module supports migrating (copying) existing Row Security defined for one Universe/Domain
(ie,
Development/Sales), to another Universe/Domain (say
Production/Sales)?

Funnily enough, I have just had to do this as we are migrating our repositories from Access (proved VERY unreliable) to OpenIngres.

To do this we have created new domains at the same time as the old ones.
On one universe we had extensive row-based security which we didn’t fancy recreating.

I can tell you how I did it, but you must bear in mind that this is unsupported by BO and you must be careful not to corrupt the security domain.

Reply if interested and I’ll send you the SQL I used.

Cheers,

Phil Morris

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
For old 3.1 info:
Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’


Listserv Archives (BOB member since 2002-06-25)