[fdo-users] KingOra Cannot Find Primary Key with Some Database Roles

[Haris Kurtagic]

If I understood correctly, you don't get primary key recognized when user
used in connection string is not owner of data ?

I am looking into code and it seems that that in such case when you do not
use 'OracleSchema' connection property of King.Oracle, primary key wouldn't
be recognized.

If you would set King.Oracle connection property 'OracleSchema' to owner of
that table then primary key in your case would be recognized ?

But then you could have Oracle user which could have access to
multiple schema's which he doesn't own and then again primary keys wouldn't
be correctly recognized.
So, on quick look it seems it is bug in provider.

Haris

On Wed, Feb 24, 2010 at 2:06 PM, Crispin_at_1Spatial <
crispin.hoult at 1spatial.com> wrote:

>
> Hi,
>
> Where a KingOra connection is made to a user that has no ownership of data
> but is instead allocated access via roles and groups (not views) the code
> that finds the PKey - GetTablePkeyColumns() - passes in the "Owner" for an
> optimised query against USER_CONSTRAINTS.
>
> Maybe it's my misunderstanding of the "Owner" -- if this the user logged
> onto the DB with the connection properties then this is wrong?  There is an
> entry against the ALL_CONSTRAINTS but that's a slow query.
>
> Maybe I am creating my connection parameters wrong?
>
> Thought I'd post here before submitting a ticket on this...
>
>  Crispin
>
> --
> View this message in context:
> http://n2.nabble.com/KingOra-Cannot-Find-Primary-Key-with-Some-Database-Roles-tp4625565p4625565.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100310/d41a90e0/attachment.html