Re: QUESTION: Changing the owner of a table

In article <1992Dec1.190822.16308_at_deepthought.uucp> Neil Greene <neil_at_ms.uky.edu> writes:

> I have about 10 tables I would like to change the owner from sys to
> someone_else. What is the best procedure for doing this and are there any
> pitfalls I may not forsee in doing this??
 

> --
> Neil Greene
> President, Kentucky NeXT User Group, Inc.
> Email: neil_at_ms.uky.edu [NeXTMail]

I have had success with the following:

1. export the tables, then
2. import the tables with the new user name, as a command line switch to the import command.

The only problem I've experienced is that the new user may have to have DBA privs during the import, but that doesn't have to be a permanent change.

Hope this helps.

--

  DISCLAIMER:  I, hereby, disclaim any disclaimer except this disclaimer.  

+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
| David Rackley                 | Now comes the really weird part...You know  |
| Applied Research Laboratories | the part where I know how to tap dance, but |
| The University of Texas       | only while wearing golf shoes...            |
| Austin, TX.  78758            |        ...Ponderous, man, really ponderous! |
| Tel: 512-835-3120             |                                             |
+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+