SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

Identifying tables where the ownership has changed
HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001
C-2
object owners are as described in step 1, and the catalog name is 'CAT', complete
the following steps:
1. Logon as
SUPER.SUPER (whose Guardian ID is 65535), the schema owner for
schema
'SCH'.
2. Run the following command for the view
SCH.V1:
GIVE VIEW CAT.SCH.V1 to "SUPER.SUPER";
--- SQL operation complete.
3. Logon as SQL.USER1 (whose Guardian ID is 44801), the schema owner for
schema
'USER1'.
4. Run the following command for table
USER1.T1:
GIVE TABLE CAT.USER1.T1 to "SQL.USER1";
--- SQL operation complete.