Re: Is there a SQL command to change table ownership?

Assumming hagen has select privs on the tables, log in as hagen and issue SQL

create table a as select * from sys.a;

verify table was created and populated then delete sys.a

HTH
Jim Gregory

>>==========Hagen Finley, 11/1/95==========
>>
>>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.
>>
>>
>>

Jim Gergory

Views and opinions expressed are mine and do not reflect my empoyer's or client's. Received on Thu Nov 02 1995 - 00:00:00 CET