Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with granting object permissions to a role
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 EggenbergerReceived on Fri Feb 07 2003 - 08:41:21 CST
![]() |
![]() |