Re: Using Oracle-OLEDB-provider to query meta-data (restrictions do not work)
From: arrrjan <muyena_at_usoft.nl>
Date: Thu, 18 Nov 1999 11:25:20 +0100
Message-ID: <810k61$ksa$1_at_porthos.nl.uu.net>
Date: Thu, 18 Nov 1999 11:25:20 +0100
Message-ID: <810k61$ksa$1_at_porthos.nl.uu.net>
I am using the openschema-method, of course. The problem is indeed to
filter it appropriately to get only the tables, constraints, indexes from a
specific user.
filter-criteria for e.g. tables are :
CATALOG,SCHEMA, TABLE_NAME, TABLE_TYPE
[Quoted] so when I try various filter-criteria like
null, <username>, null, "TABLE" or even
null, null, null, TABLE
it gives back a NOT supported !
[Quoted] only when doing the unrestricted call I get back data:
too much, messy data
[Quoted] On SQLServer my code produces excellent results.
Arjan Received on Thu Nov 18 1999 - 11:25:20 CET