Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Give user index grants Oracle 8/9i
On 17 Nov 2006 20:13:31 -0800, "Sean" <seanm555_at_comcast.net> wrote:
>So, my question is related to how to make indexes, primary key, etc.
>visible to non-owner users for tables that have public synonyms.
>
>I have a few tables set up that have public synonyms, and I use
>Microsoft ADO to pull data from these tables. Unless you log in as the
>owner of the schema, ADO can't resolve the tables' primary key
>information. If you log in as the schema owner, ADO can resolve the
>primary key just fine. So, there must be some permission in Oracle I'm
>missing to give non-owners the ability to see primary key, etc.
>metadata on the synonymmed (is that a word?) table...?
>
>Thanks,
>
>Sean
>
I don't know anything about ADO, so I've got a question: what do you
mean by "resolve the tables' primary key information"?
Regards, Jaap. Received on Sat Nov 18 2006 - 04:14:53 CST