-
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?
-
you cannot change ownership you have to create the object with the user you want, altering data dictionary will corrupt your database
-
That's what I thought.
I was just hoping that there was a way.
Oh Well!!
Thanks
-
I wish it works with chown like unix
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|