Change ownership

[DQuinn]

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?

[pando]

you cannot change ownership you have to create the object with the user you want, altering data dictionary will corrupt your database

[DQuinn]

That's what I thought.
I was just hoping that there was a way.

Oh Well!!

Thanks

[pando]

I wish it works with chown like unix

[tamilselvan]

If it is a development database,
you can change ownership by updating owner# column in obj$ table.

Do not update in a prod database.