transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner ?

Harishkumar .Pathangay

transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner ?

hi,

what is the use case for command :

transfer ownership of constraint in a table to a user other than table owner?

can I set up a table with user1 having the ability to modify the constraints on the table but he cannot do any thing else?

is there a valid scenario like that? I am not able to do that with out providing him alter privilege on the table.

wat will be the purpose of such a transfer? if I change the ownership of a table will it not change the ownership of constraint as well.

thanks,

harish p

Michael Hannan

RE: transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner ?
(in response to Harishkumar .Pathangay)

Harishkumar,

A Foreign Key Constraint belongs to the table, and have to have Alter privilege on the Table. That simple. You don't want people messing with it. Maybe someone might want to change it to not enforced, and back to enforced again. Better be the DBA who knows what he is doing.

I can't tell if your requirement is real or hypothetical, like a 'possible solution looking for a problem'. Certainly seems a bit unusual.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Harishkumar .Pathangay

transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner
(in response to Michael Hannan)
That is exactly I am also asking. Why there is a transfer ownership command
that allows me to transfer ownership of a individual constraint on a table.
I do not understand why there is a need for such a command.
Thanks.

On Wed 24 Apr, 2019, 09:05 Michael Hannan, <[login to unmask email]> wrote:

> Harishkumar,
>
> A Foreign Key Constraint belongs to the table, and have to have Alter
> privilege on the Table. That simple. You don't want people messing with it.
> Maybe someone might want to change it to not enforced, and back to enforced
> again. Better be the DBA who knows what he is doing.
>
> I can't tell if your requirement is real or hypothetical, like a 'possible
> solution looking for a problem'. Certainly seems a bit unusual.
>
> Michael Hannan,
> DB2 Application Performance Specialist
> CPT Global Ltd
>
> -----End Original Message-----
>

Harishkumar .Pathangay

RE: transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner
(in response to Harishkumar .Pathangay)

Hi,

A constraint is not an object by itself. It is a property of an object which is table. An Index is an object by itself, existing in database but it is dependent on Table Object. It is only a dependency not a property. A constraint on a table is not a dependency, rather it is a property. It exists on the table, not as a separate object. That is the crux of the question. May be I am realizing it late after posting so many comments.

thanks,

harish pathangay

Michael Hannan

RE: transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner
(in response to Harishkumar .Pathangay)

What "command" are you talking about? No such thing exists that I know of at least for DB2 z/OS.

We have ALTER table DROP constraint and
ALTER Table ADD Constraint.

Seems like you are asking something purely hypothetical to no real requirement.

I maybe not the only one who can't see what it is that you don't understand.

If ask something easy or something specific and clear, you might get a dozen replies. 

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Harishkumar .Pathangay

transfer ownership of a constraint ? can constraints be oned by a separate user besides table owner
(in response to Michael Hannan)
Thanks for your comments.
Thanks to other members also for being patient with me.
Please consider thread closed.

On Sat 18 May, 2019, 12:58 Michael Hannan, <[login to unmask email]> wrote:

> What "command" are you talking about? No such thing exists that I know of
> at least for DB2 z/OS.
>
> We have ALTER table DROP constraint and
> ALTER Table ADD Constraint.
>
> Seems like you are asking something purely hypothetical to no real
> requirement.
>
> I maybe not the only one who can't see what it is that you don't
> understand.
>
> If ask something easy or something specific and clear, you might get a
> dozen replies.
>
> Michael Hannan,
> DB2 Application Performance Specialist
> CPT Global Ltd
>
> -----End Original Message-----
>