[fdo-users] KingOra Cannot Find Primary Key with Some Database Roles
crispin.hoult at 1spatial.com
Wed Feb 24 08:06:17 EST 2010
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...
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.
More information about the fdo-users