Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with granting object permissions to a role

Re: Problem with granting object permissions to a role

From: Marc Eggenberger <marc.eggenberger_at_power.alstom.com>
Date: Fri, 7 Feb 2003 15:41:21 +0100
Message-ID: <MPG.18ade3f73398b256989693@localhost>


In article <1044627931.7561_at_news.thyssen.com>, Guido.Konsolke_at_triaton.com says...

[...]

> Hi Marc,
>
> sys is not such a big boss that he can steal / destroy / manipulate
> your objects (at least, not directly). You must log on as the user
> that owns the objects. Only the owner can grant privileges to others
> (unless another user has been granted privs ...WITH GRANT OPTION).

So if the schema is called ms2 I have to login as user ms2 and do this? How do I know excatly how is the owner of the objects? If they are in schema ertu is the user ertu the owner?

thanks for any help.

-- 
mfg
Marc Eggenberger
Received on Fri Feb 07 2003 - 08:41:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US