Is there a SQL command to change table ownership?
Date: 1995/11/01
Message-ID: <4788a1$kd1_at_sonnet1.sonnet.com>#1/1
Befogged by the enthusiam of a Oracle neo-phyte I have created three tables as 'SYS'. Now I have come to appreciate reasons why one would seek to avoid that. In particular, I have found that when I access the Oracle database via Power Objects logging in as 'SYS' I pull up every administrative table, index, view, etc. in the database which is muddlesome at best. I am sure working in a table space as 'SYS' also carries with it risks that most DBA's would consider unacceptable. Consequently, I would like to transfer the ownership of these tables to a less threatening user (me). I realize one approach to this problem would be to grant object priviledges to the tables for user:hagen but 1) I am having a little trouble with that (I have attempted to do that with the Object Manager and although the Object Manager says user:hagen has been granted the full gamut of priviledges associated with the tables, SQL*Plus tells uesr:hagen those tables don't exist), and 2), I don't know, but I am concerned that even after those priviledges have been granted, those tables won't show up when I log in as hagen using Power Objects. Therefore, I have been routing the hard soil of my SQL literature, but have yet to unearth any information which deals with altering the ownership of a table. Received on Wed Nov 01 1995 - 00:00:00 CET