Changing the owner of a table 
Author Message
 Changing the owner of a table

Hello Experts!

Are there any side-effects to changing the owner of a
table in the systables table? I normally do not mess
with system tables at all, but I accidently recreated
a table using the wrong account, and, instead of doing
things the proper way (i.e., dropping the table and
recreating it again), I was wondering if I could just
change the name of the owner in the systables table to
what I want it to be without experiencing any negative
side effects.

What are your opinions?

Thanks!
Marty
(aka Lazy in Alaska)

__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://www.***.com/



Sat, 20 Mar 2004 06:51:26 GMT
 Changing the owner of a table

Quote:

> Hello Experts!

> Are there any side-effects to changing the owner of a
> table in the systables table? I normally do not mess
> with system tables at all, but I accidently recreated
> a table using the wrong account, and, instead of doing
> things the proper way (i.e., dropping the table and
> recreating it again), I was wondering if I could just
> change the name of the owner in the systables table to
> what I want it to be without experiencing any negative
> side effects.

> What are your opinions?

> Thanks!
> Marty
> (aka Lazy in Alaska)

> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com

You should not directly change anything in the sysmaster database.
Period.


Sat, 20 Mar 2004 07:36:38 GMT
 Changing the owner of a table

Dont.

Quote:
-----Original Message-----


Sent: Tuesday, 2 October 2001 10:51 a.m.
To: informix user group
Subject: Changing the owner of a table

Hello Experts!

Are there any side-effects to changing the owner of a
table in the systables table? I normally do not mess
with system tables at all, but I accidently recreated
a table using the wrong account, and, instead of doing
things the proper way (i.e., dropping the table and
recreating it again), I was wondering if I could just
change the name of the owner in the systables table to
what I want it to be without experiencing any negative
side effects.

What are your opinions?

Thanks!
Marty
(aka Lazy in Alaska)

__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com



Sat, 20 Mar 2004 07:09:07 GMT
 Changing the owner of a table

Ok, I won't!  Just thought I'd ask!

Thanks!


Quote:
> Dont.

> -----Original Message-----


> Doom Dog
> Sent: Tuesday, 2 October 2001 10:51 a.m.
> To: informix user group
> Subject: Changing the owner of a table

> Hello Experts!

> Are there any side-effects to changing the owner of
> a
> table in the systables table? I normally do not mess
> with system tables at all, but I accidently
> recreated
> a table using the wrong account, and, instead of
> doing
> things the proper way (i.e., dropping the table and
> recreating it again), I was wondering if I could
> just
> change the name of the owner in the systables table
> to
> what I want it to be without experiencing any
> negative
> side effects.

> What are your opinions?

> Thanks!
> Marty
> (aka Lazy in Alaska)

> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com

__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com


Sat, 20 Mar 2004 07:21:12 GMT
 Changing the owner of a table

with that said, what is the best way to change the ownership of a table.
You can't use rename (though that would be so easy to do). And doing an
export/drop/add with a new ownername seems to be a bad thing to do to a
production server.  You would think all it should take is a locked table
row here and there modify the contents...and then unlock and go is all
that is really necessary.  

I am about to have to change the ownership of a ton of accounts on our
production server so that their ownerships correspond to a production
control type of account and allow me to keep the informix id and password
under wraps.  Being more of a DBSA is a negative overall.

Scott

Quote:


> > Hello Experts!

> > Are there any side-effects to changing the owner of a
> > table in the systables table? I normally do not mess
> > with system tables at all, but I accidently recreated
> > a table using the wrong account, and, instead of doing
> > things the proper way (i.e., dropping the table and
> > recreating it again), I was wondering if I could just
> > change the name of the owner in the systables table to
> > what I want it to be without experiencing any negative
> > side effects.

> > What are your opinions?

> > Thanks!
> > Marty
> > (aka Lazy in Alaska)

> > __________________________________________________
> > Do You Yahoo!?
> > Listen to your Yahoo! Mail messages from any phone.
> > http://phone.yahoo.com

> You should not directly change anything in the sysmaster database.
> Period.



Sat, 20 Mar 2004 10:19:45 GMT
 Changing the owner of a table

Why does the owner of the table have any relevance to the informix id and
password?  With the exception of Peoplesoft which is programmed to want the
owner as psprod, pstest or something, it should not matter.

The table owner and any user that may exist are completely independant.  I
own tables at client sites but do not have a (personal) login there.  Any
DBA does the administration when required.

MW

Quote:
-----Original Message-----


Sent: Tuesday, 2 October 2001 2:20 p.m.
To: Victor Glass

Subject: Re: Changing the owner of a table

with that said, what is the best way to change the ownership of a table.
You can't use rename (though that would be so easy to do). And doing an
export/drop/add with a new ownername seems to be a bad thing to do to a
production server.  You would think all it should take is a locked table
row here and there modify the contents...and then unlock and go is all
that is really necessary.

I am about to have to change the ownership of a ton of accounts on our
production server so that their ownerships correspond to a production
control type of account and allow me to keep the informix id and password
under wraps.  Being more of a DBSA is a negative overall.

Scott



> > Hello Experts!

> > Are there any side-effects to changing the owner of a
> > table in the systables table? I normally do not mess
> > with system tables at all, but I accidently recreated
> > a table using the wrong account, and, instead of doing
> > things the proper way (i.e., dropping the table and
> > recreating it again), I was wondering if I could just
> > change the name of the owner in the systables table to
> > what I want it to be without experiencing any negative
> > side effects.

> > What are your opinions?

> > Thanks!
> > Marty
> > (aka Lazy in Alaska)

> > __________________________________________________
> > Do You Yahoo!?
> > Listen to your Yahoo! Mail messages from any phone.
> > http://phone.yahoo.com

> You should not directly change anything in the sysmaster database.
> Period.



Sat, 20 Mar 2004 10:46:12 GMT
 Changing the owner of a table
Flame me, but I did it once (think it's about a year ago) in my testing
environment without any negative side-effects.
But I changed all the accounts of the corresponding sysconstraints &
sysindexes ...  too.
And of course my Server does'nt really care about users as I granted all
permissions to everyone
(as the application manages the user-access permissions).



Quote:

> Hello Experts!

> Are there any side-effects to changing the owner of a
> table in the systables table? I normally do not mess
> with system tables at all, but I accidently recreated
> a table using the wrong account, and, instead of doing
> things the proper way (i.e., dropping the table and
> recreating it again), I was wondering if I could just
> change the name of the owner in the systables table to
> what I want it to be without experiencing any negative
> side effects.

> What are your opinions?

> Thanks!
> Marty
> (aka Lazy in Alaska)

> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com



Sat, 20 Mar 2004 17:06:59 GMT
 Changing the owner of a table

This is a multi-part message in MIME format.
--------------C87D3811936C4C6AAB7F251C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Don't do it ! One of my colleagues (not myself obviously) did exactly
this and the database became inconsistent and had to be completely
restored.

Quote:

> Flame me, but I did it once (think it's about a year ago) in my testing
> environment without any negative side-effects.
> But I changed all the accounts of the corresponding sysconstraints &
> sysindexes ...  too.
> And of course my Server does'nt really care about users as I granted all
> permissions to everyone
> (as the application manages the user-access permissions).



> > Hello Experts!

> > Are there any side-effects to changing the owner of a
> > table in the systables table? I normally do not mess
> > with system tables at all, but I accidently recreated
> > a table using the wrong account, and, instead of doing
> > things the proper way (i.e., dropping the table and
> > recreating it again), I was wondering if I could just
> > change the name of the owner in the systables table to
> > what I want it to be without experiencing any negative
> > side effects.

> > What are your opinions?

> > Thanks!
> > Marty
> > (aka Lazy in Alaska)

> > __________________________________________________
> > Do You Yahoo!?
> > Listen to your Yahoo! Mail messages from any phone.
> > http://phone.yahoo.com

--------------C87D3811936C4C6AAB7F251C
Content-Type: text/x-vcard; charset=us-ascii;
 name="risavage.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Richard Savage
Content-Disposition: attachment;
 filename="risavage.vcf"

begin:vcard
n:Savage;Richard
tel;cell:07790 777135
tel;work:01784 448760
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1

end:vcard

--------------C87D3811936C4C6AAB7F251C--



Sun, 21 Mar 2004 15:16:26 GMT
 Changing the owner of a table

Quote:
----- Original Message -----


Sent: Monday, October 01, 2001 7:36 PM
Subject: Re: Changing the owner of a table

> You should not directly change anything in the sysmaster database.
> Period.

Directly changing anything in sysmaster would be a trick.  Perhaps you mean
the system catalogues.  In which case I couldn't agree with you more.

cheers
j.



Sun, 21 Mar 2004 20:41:12 GMT
 Changing the owner of a table

Quote:

> Hello Experts!

> Are there any side-effects to changing the owner of a
> table in the systables table? I normally do not mess
> with system tables at all, but I accidently recreated
> a table using the wrong account, and, instead of doing
> things the proper way (i.e., dropping the table and
> recreating it again), I was wondering if I could just
> change the name of the owner in the systables table to
> what I want it to be without experiencing any negative
> side effects.

> What are your opinions?

> Thanks!
> Marty
> (aka Lazy in Alaska)

> __________________________________________________
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com

I've already responded to this post. After reading the other responses,
I've concluded that just saying 'don't do it' is good advice, but
doesn't define the problem. A less black and white answer to 'Are there
any side effects to changing the owner of a table in the systables
table?' is: no, if you do it correctly.

The more basic issue involves multiple interfaces to the same data, and
the possible effects of 'back ending' the standard interface. Marty is
aware that the systables table can be accessed like any other table by
the owner, which in this case is usually informix. Changing the value of
a single field is a tempting alternative to rebuilding and reloading a
table just to change the owner. Alternatively by dropping and creating
the table, Marty would let the database engine interface with the
systables table (and any other tables involved) instead of his
interfacing with it directly. The up side to letting the engine do the
work is (a) doing so is supported by Informix and they will work with
you if there is a problem, (b) the engine code that does the work has
been tested and is tried and true, and is based on a detailed
understanding of the architecture and requirements of system catalogues
in a database. The down side to Marty doing the work is the converse.



Sun, 21 Mar 2004 23:40:23 GMT
 Changing the owner of a table
For online this owner is also held in a page
(somewhere in the tblspace tblspace) which is
not updated when you update systables).

Can we get a feature request to Informix for this?
Surely easy to do and very useful?

But like the fact that 'rename index' is now
available in 7.31!


Quote:

> > Hello Experts!

> > Are there any side-effects to changing the owner of a
> > table in the systables table? I normally do not mess
> > with system tables at all, but I accidently recreated
> > a table using the wrong account, and, instead of doing
> > things the proper way (i.e., dropping the table and
> > recreating it again), I was wondering if I could just
> > change the name of the owner in the systables table to
> > what I want it to be without experiencing any negative
> > side effects.

> > What are your opinions?

> > Thanks!
> > Marty
> > (aka Lazy in Alaska)

> > __________________________________________________
> > Do You Yahoo!?
> > Listen to your Yahoo! Mail messages from any phone.
> > http://phone.yahoo.com

> I've already responded to this post. After reading the other responses,
> I've concluded that just saying 'don't do it' is good advice, but
> doesn't define the problem. A less black and white answer to 'Are there
> any side effects to changing the owner of a table in the systables
> table?' is: no, if you do it correctly.

> The more basic issue involves multiple interfaces to the same data, and
> the possible effects of 'back ending' the standard interface. Marty is
> aware that the systables table can be accessed like any other table by
> the owner, which in this case is usually informix. Changing the value of
> a single field is a tempting alternative to rebuilding and reloading a
> table just to change the owner. Alternatively by dropping and creating
> the table, Marty would let the database engine interface with the
> systables table (and any other tables involved) instead of his
> interfacing with it directly. The up side to letting the engine do the
> work is (a) doing so is supported by Informix and they will work with
> you if there is a problem, (b) the engine code that does the work has
> been tested and is tried and true, and is based on a detailed
> understanding of the architecture and requirements of system catalogues
> in a database. The down side to Marty doing the work is the converse.



Tue, 23 Mar 2004 05:20:57 GMT
 
 [ 11 post ] 

 Relevant Pages 

1. Changing the owner of a table

2. Is there any way to change the owner of a table

3. Changing the Owner of a table??

4. how to Change the owner of a table?

5. Change the owner of a table

6. Changing the owner of a table

7. Changing the owner of a table

8. Changing the owner of a table

9. Changing the owner of a table ???

10. Changing of owner of a table

11. Change the owner of a table

12. Change DB owner/Table owner


 
Powered by phpBB® Forum Software