Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003

    Unanswered: how to change schema ownership ?

    Can we change schema ownership ?
    I mean,if set of objects owned by 'db1schema' can we change it to 'db2newuser' schema ?
    if so how ?
    Please help.
    thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Not aware of any such command which can do this but you can use db2move utility to extract data and table structure and then change one of the log file generated by utility. Do find/replace and specify new user so when you do import tables are created for that user and data loaded.

    There are other ways to do the same, db2move is only one such.


  3. #3
    Join Date
    Nov 2003
    OK.then can any user inpersonate other user so they don't need to make like :
    select db2usr1schema.table1 ( db2user2 makes this query) instead they can just impersoname 'db2usr1schema' owner and make simple by:
    select table1 , as if it were created by him ?

  4. #4
    Join Date
    Jan 2003
    Provided Answers: 5
    Yes, look as SET CURRENT SCHEMA SQL Command (in SQL Reference manual).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts