Change ownership
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Change ownership

  1. #1
    Join Date
    Mar 2001
    Posts
    82
    Hi,

    How do you change ownership for an object(table).
    Do you just update the dba_objects table or do you need to
    change other things?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot change ownership you have to create the object with the user you want, altering data dictionary will corrupt your database

  3. #3
    Join Date
    Mar 2001
    Posts
    82
    That's what I thought.
    I was just hoping that there was a way.

    Oh Well!!

    Thanks

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I wish it works with chown like unix

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If it is a development database,
    you can change ownership by updating owner# column in obj$ table.

    Do not update in a prod database.

Posting Permissions

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


Click Here to Expand Forum to Full Width