Quite often we need to set the same properties for several objects in the physical model. It would be very time consuming if we do it one by one… Luckily the tool offers a way to do it much easier.

I would like to set the schema owner to all my tables to PROD. How do I do it?

First set the property for one of the tables:

Prop1

Then press Propagate Properties.

Prop2

Since we only want to copy the property User, press Deselect All (in the upper part of the screen, Properties section), then select User:

Prop3

Select all the tables in the bottom of the screen by pressing Select All in the Object section of the screen:

Prop4

Then press OK.

Now the schema owner for all the tables has been changed to PROD:

Prop5

 

 

Advertisements