Hey Dan,
I guess you gave up! Hehe. Either the SYSADM, SECADM, or the owner
of the object can transfer ownership.

1. db2cmd
2. db2 connect to sample user db2admin using db2admin
3. db2 transfer ownership of table edtest3 to user DEPDB preserve
privileges



-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x12748559.[Email address protected]
Sent: Thursday, December 27, 2007 9:25 AM
To: LazyDBA Discussion
Subject: RE: DB2 Version 9.1, LUW

Well, well, well!
It's Dan Luchinski! Hehe. How have you been? Oh my! Phew! You win
"the COKE"! hehe.

Now, the next question is: Who can transfer ownership of a DB2
object?






Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Dr. Eric J. Smith is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: DanLuchinski
[mailto:db2udbdba-ezmlmshield-x21612925.[Email address protected]
Sent: Thursday, December 27, 2007 9:10 AM
To: LazyDBA Discussion
Subject: Re: DB2 Version 9.1, LUW

1. Yes (must be because number 2 and 3 is looking for more information
on
a YES) ;-)

2. transfer ownership

3. aliases, constraints, database partition group, event monitor,
function, specific function, index, index extension, method, specific
method, nickname, package, procedure, specific procedure, schema,
sequence, table, table hierarchy, tablespace, trigger, type, type
mapping,
view, view hierarchy and xsrobject.

Dan Luchinski
Database Administrator
ASPCA Knowledge Management Center
University of Illinois Allied Agency
Phone: 217.337.9777 Fax: 217.337.0599 Web: www.aspca.org

"Edwards Ed " <db2udbdba-ezmlmshield-x96109765.[Email address
protected]
wrote on 12/27/2007 08:02:51 AM:

> Well, well, well!
> I'm back! And that's a threat! Hehe. Ahhhhh, yes! Red Stripe!
> Hehe. I just got back from IBM Webshpere Application Server V6.1
> Administration training in Hot Lanta (Atlanta, Georgia)! It was a
great
> class and I learned a lot! Hehe.
>
> Not so fast! Hehe. It's test time! Can you win "the COKE"? hehe.
>
>
> 1. In DB2, version 9, can you transfer ownership of an object?
>
> 2. If your answer is yes, what is the command that you use?
>
> 3. If your answer is yes, what objects can you transfer ownership of?
>
>
> It's Fridayyyyyyyy! Partyyyyyyyyyyy! Hehe.
>
>
> Please take a few minutes to provide feedback on the quality of
> service you received from our staff. The Department of Education
> values your feedback as a customer. Commissioner of Education Dr.
> Eric J. Smith is committed to continuously assessing and improving
> the level and quality of services provided to you.Simply use the
> link below. Thank you in advance for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address
protected]
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page