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: Give user index grants Oracle 8/9i

Re: Give user index grants Oracle 8/9i

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 18 Nov 2006 10:14:53 GMT
Message-ID: <455edc83.1539296@news.hetnet.nl>


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

Original text of this message

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