XTR: Change the owner of XTR installation.

XTR: Change the owner of XTR installation.


Step 1: Change the owner of non SQL files in the XTR installation
Command;
FUP GIVE <$vol>.<xygatetr>.* WHERE NOT SQL AND NOT OWNER = <new-owner>, <new-onwer>

Step 2: Change the owner of SQL Catalogs in the XTR installation
Command;
SQLCI ALTER CATALOG <$vol>.<xygatetr> OWNER <new-owner>;

Step 3: List the SQL Tables not owned by <new-owner> in the XTR installation
Command;
FUP INFO <$vol>.<xygatetr>.* WHERE TABLE AND NOT OWNER = <new-owner>

Step 4: Change the owner of SQL Tables not owned by <new-owner> in the XTR installation
Command;
SQLCI ALTER TABLE <$vol>.<xygatetr>.<tbl> OWNER <new-owner>;


Example;
- current owner: 111,11
- new-owner: 222,22
- XTR installation: $V99.XYGATETR

Step 1 example;
(logon as 111,11) TACL> FUP GIVE $V99.XYGATETR.* WHERE NOT SQL AND NOT OWNER = 222,22, 222,22
Step 2 example;
(logon as 111,11) TACL> SQLCI ALTER CATALOG $V99.XYGATETR OWNER 222,22;
Step 3 example;
(logon as 111,11) TACL> FUP INFO $V99.XYGATETR.* WHERE TABLE AND NOT OWNER = 222,22
Step 4 example (all TABLEs listed in the command output in Step 3);
(logon as 111,11) TACL> SQLCI ALTER TABLE $V99.XYGATETR.PDBTBL OWNER 222,22;