Showing posts with label takeover. Show all posts
Showing posts with label takeover. Show all posts

Thursday, 10 March 2016

Inactive versions - Switch Ownership

Multiple developers work on modeling Information views based on many tables belongs to schema. The information views will become Active version of object only when it is 'Activated' after 'Save and Validation'. After building the information view if the user only 'save and validate' and does not activate, it becomes the Inactive version of the object.

If one user just created the object, then it is possible to take over that object by another user as long as it is inactive version of the object. This concept is called as "Take Over" or "Switch Ownership". The difference between these two is:

Take Over: To take single inactive object from another workspace.
Switch Ownership: To take single or multiple inactive objects from other users.

In this blog we will have a look on Switch Ownership (version SPS 05 Revision 47).
For simplicity we assume that there are two users (USER1 , USER2) working on two tables (EMPLOYEE, DEPT) on which Analytic view is based on schema "SRK" and both the users have the same privileges but USER1 developing views in system (HAN(USER1)) and USER2 in system (HAN(USER2)).