Re: Problem with granting object permissions to a role

In article <MPG.18ade3f73398b256989693_at_localhost>, Marc says...
>
>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?

I didn't see any version numbers in your posting, so there might be two answers to this. Prior to 9.2 you needed to log on as the owner of the object or someone who had been granted access WITH GRANT OPTION (that last bit allows them to pass it on). In 9.2, this is no longer the case (sounds of the Hallelujah Chorus resound!). ANyone with DBA privileges can grant access in 9.2 (can't remember off the top of my head if this comes with the DBA role or SYSDBA).
>
>thanks for any help.
>
>--
>mfg
>Marc Eggenberger

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Feb 07 2003 - 10:55:17 CST