I attached example package. Bellow are some instruction how to work with it.
1. Switch On Expert Mode
Go to "Main Menu - Settings- Options - General" there is checkbox "Expert Mode". Check it if not. Now you have available some additional functionality of TDM.
2. Import Package
Unpack package somewhere on disk.
Go to "Main Menu - Expert Mode - Customization - Import Custom Package". Select this package and confirm it.
3. Open Package Explorer
Go to "Main Menu - Expert Mode - Customization - Package Explorer". Now you have in right side of TDM docked package explorer. You can filter system packages by click on ikon "Hide System Package". In packages should be package Assignment.
4. Edit Macros
In package explorer you can see two macros. One is called ReplaceUser and second ChangeRole. You can see its source code by double click on each macro. Source Code is wrote in JScript. You can modify it how you need.
When you click by right-click on macro you can select form popupmenu item "Properties". In this dialog you can modify caption, position on main menu and popup menu and other.
5. Call Macro ReplaceUser
Open any Oracle model and go to main menu - Macros. There should be new item "Replace User". Select it, you get dialog where you can select Current User and New User. This macro set User to New User in all entities and sequences, where is Current User.
6. Call Macro Change Role
This macro is only as draft, because I don't know exact rules for replace roles (Source Code is commented). You can right click on Entity. And from popup menu choose "Macros - Change Roles".
This Macro change user of permissions to user that is assigned to Entity.
I hope it will help you.
Unfortunately permission in sequences are only on After script now. There are no better way. If you want improve this feature please enter record to Idea pond on this pages.
If you will have any next questions don't hesitate contatc me
Assignment.zip (2.14 KB)