SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-237
Examples of GIVE Object
schema owner. After successful completion of this operation, all the existing opens of
the target object are invalidated. In case of VIEW ownership change, the existing
opens on the underlying tables are also invalidated.
Examples of GIVE Object
•
This example transfers the table ownership to “SQL.USER2”.
>>give table usertable to "sql.user2";
--- SQL operation complete.
•
This example transfers view ownership to “SQL.USER5”.
>>give view userview to "sql.user5";
--- SQL operation complete.
•
This example transfers procedure ownership to “SQL.USER3”.
>>give procedure userroutine to "sql.user3";
--- SQL operation complete.
•
This example transfers trigger ownership to “SQL.USER1”:
>>give trigger usertrigger to "sql.user1";
--- SQL operation complete.
•
This example transfers sequence generator ownership to “SQL.USER1”:
>>give sequence myseq to "sql.user1";
--- SQL operation complete.