Path: utzoo!attcan!uunet!snorkelwacker!apple!oracle!news From: dsimson@oracle.com (David Simson) Newsgroups: comp.databases Subject: Re: table ownership under Oracle Message-ID: Date: 13 Jun 90 16:22:59 GMT References: <10426@hydra.gatech.EDU> Sender: news@oracle.com Organization: Oracle Corporation, Belmont, CA Lines: 22 In-reply-to: scott@prism.gatech.EDU's message of 13 Jun 90 13:30:42 GMT > Does anyone know of a quick way to change the ownership of an > Oracle table in release 6.0.30? I had considered simply changing > the appropriate fields in the sys.obj$ table, but I am not > very comfortable with this since I don't know all the ramifications. I don't know all the ramifications either, but I'd never do it! > We are migrating to release 6.0.30 from release 5.1.22 and > are also changing all our accounts to "automatic" (OPS$) in > a database we use for instructional support. Since you're doing a v5 to v6 upgrade you'll be exporting each user. Instead of doing a full database export that preserves user names, export and import each user individually. That way, when you import the tables they'll be owned by the new OPS$ user. > - Scott Dave Simson dsimson@oracle.com (415) 598-8013