Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Germany
    Posts
    10

    Question Unanswered: Table owner will be removed

    Hello,
    we are running Informix 7.31 on WindowsNT4.0.
    Most of the tables are owned by one domain user. Now the domain will be removed and this user will not exist any longer.
    So what to do?

    Can I create a local user with the same user name? Will the IDS notice, that the table owner is the domain-user and not the local user? Or does the IDS take only the user name? (The IDS is installed locally, not in domain mode.)

    Or can I change the owner of the tables via an sql command?
    How does this work?

    Thanks a lot for your help in advance.
    Best regards
    Regina

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Why do you need this user? If you just grant permissions to another user you can access the table with that user.
    IDS will not check whether the owner of the table still exists.

    You will only have a problem when you want to create new tables with that old user-id, which you probably don't want.

    My opinion is that you can just delete the user after you granted some permissions to another user.
    rws

Posting Permissions

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