Problem with granting object permissions to a role

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 7 Feb 2003 17:02:24 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70346D5F6@lnewton.leeds.lfs.co.uk>

Afternoon,

under normal circumstances, the user who creates an object in Oracle, owns it. So, if a table appears in user_tables for user ms2, then that table is owned by ms2.

It is unlikely that another user would do something like 'create table MS2.example(...)' but it could happen I suppose.

Basically, in a specific user USER_XXX tells you what 'XXX' objects are owned by the user, ALL_XXX tells you what 'XXX' obects the user can access (and who actually owns them). XXX can be tables, indexes, sequences etc.

HTH Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Marc Eggenberger [mailto:marc.eggenberger_at_power.alstom.com] Posted At: Friday, February 07, 2003 2:41 PM Posted To: server
Conversation: Problem with granting object permissions to a role Subject: Re: Problem with granting object permissions to a role

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

[...]

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? Received on Fri Feb 07 2003 - 11:02:24 CST